Solved

How do i connect ms sql 2000 server  to mysql?

Posted on 2010-08-24
4
264 Views
Last Modified: 2012-05-10
i have data residing on my sql 2000 server and would like the data available on the web through mysql database.
i want to transfer data from sql 2000 to mysql residing on the webserver. i have mysql drivers install on my sql 2000.
How do i configure DTS to transfer data to mysql remotely.
0
Comment
Question by:snmomodu
4 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 250 total points
ID: 33516877
The first thing you will want to do is setup linked server from MS SQL to MySQL.
http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

You can then do queries. This is helpful if you need to setup a scheduled insert of rows from SQL to MySQL.
0
 
LVL 4

Assisted Solution

by:Fugas
Fugas earned 250 total points
ID: 34937820
The easiest way is to install mysql ODBC driver on your MS SQL machine, allow access to your MySQL database on webserver to it. Then you can have a stored procedure which can synchronize your data between these two, or trigger those table on SQL server, you want to synchronize. But I also think the best way is to connect your scripts from webserver directly to your SQL server.
0
 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 37265886
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question