August 23, 2011 at 1:29 pm
Hi all,
I need to migrate large MS SQL 2005 database (2,000,000+ rows) to MySQL. Later I will also need to updated some data in MS SQL and then synchronize it with MySQL without overwriting the entire table. Can you suggest any tools to do this job?
Your help is greatly appreciated,
Hans
August 24, 2011 at 8:14 am
If you "just" want to copy data, I would recommend to use bcp and generate files. Then use some MySQL tools to get the data back in (those tools exist, I hope...).
If you need to sync the data just one way (SQL Server to MySQL) you have several options:
1) using a LastModified datetime column and export all rows with a value larger than the latest export date
2) keep the original data in a SQL Server snapshot and compare on the SQL Server side only
3) re-import the exported data, perform your comparison and drop the staging table
4) create a linked server to MySQL and compare the tables as needed.
The order listed above would also be my personal order of preference. The linked server approach is the last one since it will put quite some load on your system (data will be copied from MySQL to the local system slowing down both processes)
November 21, 2011 at 12:36 am
Take a look at http://www.convert-in.com/mss2sql.htm
It can either migrate MS SQL data into new MySQL database or synchronize existing databases.
Radjiv
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply