Solved

How do i connect ms sql 2000 server  to mysql?

Posted on 2010-08-24
4
260 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
Comment Utility
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
Comment Utility
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 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now