Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 13 down vote favorite
8

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?

share|improve this question
1  
Have you seen this question? It's about replicating data from MySql to MSSQL. Maybe you'll find some hints there. – Marian Jun 3 '11 at 21:38
@Marian Thanks for the link. Using the MySQL server as a linked server in SQL Server seems to be a solution for my problem. – murgatroid99 Jun 6 '11 at 18:00
I would suggest to use MySQL Migration Toolkit as that's what Im using but you have to modify the structure in order to accept it to MySQL. – James Wise Jul 25 '12 at 7:00
How much data are we talking about? 5mb? 3TB? – AaronJAnderson Feb 5 at 23:40
I think it was GBs or 10s of GBs, but I don't really remember because this question is from a year and a half ago. – murgatroid99 Feb 6 at 0:25

6 Answers

up vote 12 down vote

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.

share|improve this answer
1  
+1 for the migration links. – StanleyJohns Jun 6 '11 at 12:51
I would prefer not to use any commercial products if I can avoid them. I tried using the Migration Toolkit, but I think it is incompatible with the newest version of MySQL: the generated SQL insert statements had an enormous number of syntax errors and the generated tables had no rows after running the wizard. The shareware tools also seem to be made to work with older versions of MySQL. Thanks for trying. – murgatroid99 Jun 6 '11 at 17:31
up vote 3 down vote

Have you looked into using SSIS for this task? This is the ETL tool for SQL Server and it has lots of transformations and logic that could help you perform this task.

share|improve this answer
The Import/Export Wizard I mentioned using actually creates SSIS packages. The problem I had was that SSIS uses XML files to store data about how to convert between types in different database management systems, and those files did not exist for MySQL. – murgatroid99 Jun 6 '11 at 17:37
up vote 3 down vote

I tried Migration toolkit to import from SQL server to MySQL. But found SQLyog Import external data good. I could schedule the import process and also do necessary mappings to import to an existing table. Download from here.

enter image description here

share|improve this answer
up vote 2 down vote accepted

Based on Marian's suggestion, I found this answer about replicating in the other direction by setting up the MySQL server as a linked server in MS SQL Server. With MySQL set up as a linked server, I can run SQL queries on both databases at the same time, which provides exactly the functionality I needed to solve this problem.

share|improve this answer
up vote 2 down vote

MySQL Workbench can do this:

http://dev.mysql.com/downloads/workbench

It can be installed directly on the MS SQL Server machine (speed advantage!), which needs to be able to access your Ubuntu MySQL Server.

share|improve this answer
According to the documentation, MySQL Workbench does not have this capability, but a future version will. – murgatroid99 Jun 6 '11 at 17:32
1  
This has been added to the latest version of MySQL Workbench. – John Allers Aug 20 '12 at 22:15
up vote -1 down vote

http://dbconvert.com/convert-mssql-to-mysql-pro.php is able to do data mapping between MSSQL and MySQL. Just choose data types you need for the target fields or the most appropriate data types for the source type and our program will automatically transform types from one specific format to another.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.