Re: How to connect SqlServer from MySql

[Sergio de la Cruz]

Hi Raj:

The now outdated MySQL Migration Toolkit ( http://downloads.mysql.com/archives.php?p=MySQLDeveloperSuite&v=1.1.10 ) that should help you with your data migration. Be aware that this product is phased out (it will be redesigned and shipped with MySQL Workbench in the future).

If that fails, I would advise you to google around for how to export your data in MS SQL Server to some format (say CSV) that you can use with mysqldbimport (a script from MySQL Utilities) that is shipped with MySQL Workbench. Run mysqldbimport with the --help option to learn how to use it.

Otherwise, the other thing you can do is to write yourself a script to connect to your MS SQL Server server (you can use pyodbc to handle the connection in case you use python as the scripting language) and extract the relevant data converting it into MySQL INSERT statements that you can later fetch into your MySQL Server.

Hope this helps.

Sergio A. de la Cruz Rodríguez
Software Developer
Oracle Corp.