Search code examples
mysqlsql-serverdatabase-migration

Open source tool for MS SQL to SQL data migration (different schemas)

I am working on a project to migrate databases from MS-SQL Server to MySQL and looking for open-source libraries or tools that would make my job easier, provided that the source and destination DBs wouldn't be the same. (The migration is not just a replication as it involves different schemas for both the source and destination databases.) I searched for the available tools and found these:

  1. jTDS
  2. Microsoft JDBC 4.0
  3. MDB tools (Migrate MS Access to MySQL)

I am planning to run a batch job and use jTDS library to read the data from MS-SQL Server and then dumping them in MySQL. Is this the best way to go about it? It would be helpful if one could direct me towards a good tool and the good way to handle this.

Solution

  • I have had extremely good experiences with the SQL Server Migration Assistant for MySQL, this was going from MySQL to SQL Server. http://www.microsoft.com/en-us/download/details.aspx?id=28764

    But for MySQL I believe the URL you want is: http://www.mysql.com/why-mysql/white-papers/guide-to-migrating-from-sql-server-to-mysql/