Solved

How do i connect ms sql 2000 server  to mysql?

Posted on 2010-08-24
4
265 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 60

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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
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.

734 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