Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 convert MS SQL database to MySQL

Author  Topic 

hans_belgim
Starting Member

2 Posts

Posted - 2011-08-23 : 15:16:08
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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-23 : 15:21:51
You can use SSIS for this work.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

radjiv1
Starting Member

3 Posts

Posted - 2011-08-24 : 11:35:29
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
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-08-24 : 12:24:48
Well I suppose you could pay for a product like that, but SSIS is free.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -