MySQL to SQL Server transferring data

mysql sql-server ssis dts
andrewWinn picture andrewWinn · Dec 2, 2009 · Viewed 14.7k times · Source

I need to convert data that already exists in a MySQL database, to a SQL Server database.

The caveat here is that the old database was poorly designed, but the new one is in a proper 3N form. Does any one have any tips on how to go about doing this? I have SSMS 2005.

  1. Can I use this to connect to the MySQL DB and create a DTS? Or do I need to use SSIS?
  2. Do I need to script out the MySQL DB and alter every statement to "insert" into the SQL Server DB?

Has anyone gone through this before? Please HELP!!!

Answer

3Dave picture 3Dave · Dec 2, 2009

See this link. The idea is to add your MySQL database as a linked server in SQL Server via the MySQL ODBC driver. Then you can perform any operations you like on the MySQL database via SSMS, including copying data into SQL Server.

Congrats on moving up in the RDBMS world!

Related questions

How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More
update columns values with column of another table based on condition

I have two tables... table1 ( id, item, price ) values: id | item | price ------------- 10 | book | 20 20 | copy | 30 30 | pen | 10 ....table2 ( id, item, price) values: id | item | price ------------- 10 | book | 20 20 | book | 30 Now I want to: update table1 set table1.Price = table2.price where table1.…

Read More
Differences between MySQL and SQL Server

I'm an ASP.NET developer who has used Microsoft SQL Server for all my database needs (both at work and for personal projects). I am considering trying out the LAMP stack for some of my personal projects. What are some …

Read More