I have a database on SQL Server 2008 on a Windows server and I want to move all of the data to a MySQL database on a Ubuntu server. I have tried using the SQL Server Import and Export Wizard with the MySQL ODBC driver, and it correctly accesses both databases, but the xml files containing the specifications for type conversion did not exist and the specifications were too limited for me to correctly create them. Does anyone know either how to create the type conversion files or where to get a better tool for transferring this data?
SQL Server to MySQL Migration – How to Migrate Databases
migrationMySQLsql server
Related Question
- SQL Server to MySQL – How to Migrate Using MySQL Workbench Tool
- Migration of oracle xe 10 to xe 11 fails with wrong paths used in the import
- Mysql – Migrating from Oracle to MySQL via MySQL workbench: Table list is empty
- SQL Server to MySQL – Migrating Backup for a WordPress Site
- Sql-server – Migrate MySQL to MSSQL with views
Best Answer
I have two suggestions:
1) I hate bringing up commercial products but there is a $49.00 tools to Migrate MSSQL to MySQL
2) Try MySQL's MSSQL Migration forums for further suggestions
UPDATE 2011-06-03 18:03 EDT
There is an old product that went EOL back in January 2010 called the MySQL Migration Toolkit. If you can get a hold of it, you can use it.
UPDATE 2011-06-03 18:06 EDT
I found the archives !!! Here is the MySQL Migration Toolkit
UPDATE 2011-06-03 18:11 EDT
Here is the MySQL Migration Toolkit Overview
UPDATE 2011-06-03 19:08 EDT
Another commerical product ($29)
UPDATE 2011-06-03 19:30 EDT
Here is a list of Freeware tools that Migrate MSSQL to MySQL.
UPDATE 2011-06-15 17:47 EDT
Get the WhitePaper (PDF) from Oracle on the Guide to Migrating Microsoft SQL Server to MySQL (Still Commercial)
UPDATE 2012-08-21 01:24 EDT
According to this MySQL WebPage, the section
MySQL Workbench: Database Migration Wizard
claims that the MySQL Workbench has the capability of Migrating DB Objects from SQL Server to MySQL.