Take the 2-minute tour ×
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.

I'm trying to migrate a SQL Server db to MySQL, and I'm having a tough time. I've tried:

  • MySQLWorkbench -- migration tool fails because my login only shows views in SQL Server, not the tables themselves, and so I can't get past the "Schemata Selection" screen.

  • sqlcmd and bcp -- both fail because they can't export csv properly. They don't quote strings with commas in them. Plus, they don't create table schemas in MySQL.

  • SQLyog -- just fails. Creates a MySQL table from a MS SQL view ok, but doesn't import the data. Also takes a really long time on small tables, and I have to import millions of rows.

Anyone have suggestions?

share|improve this question

migrated from serverfault.com Mar 29 '13 at 17:41

This question came from our site for professional system and network administrators.

1  
There is a related topic here with quite a bit of activity. dba.stackexchange.com/questions/3153/… Perhaps you could use some type of schema comparison tool to generate a script file and then make it mysql compliant if it is not generated that way? –  Robert Gannon Mar 29 '13 at 18:00
    
Regarding your first point (getting past the schemata selection screen) i had a similar problem - you have to login as sa stackoverflow.com/questions/22570252/… –  Peter Mar 26 at 10:31
add comment

3 Answers

If you want to quickly migrate your data from MS SQL Server to MySQL, I suggest using the Migration tool from Oracle. This can really save you some time and effort.

This article can help you get started:

http://www.infoq.com/news/2012/08/MySQL-Migration

share|improve this answer
1  
Thanks. The Oracle migration tool is integrated into MySQLWorkbench, and it doesn't work for the reason in my first bullet point above. –  ccleve Jun 28 '13 at 17:32
add comment

There is another approach although it might have limitations regarding size. Use MS Access as an intermediary. It contains a Table export option that you can use with and ODBC connection to send the table to MySQL.

Also, even if sqlcmd/bcp do not produce proper csv, can you not filter the csv files?

share|improve this answer
add comment

If mysql is visible as an ado data source, use SSIS , part of SQL Server: http://msdn.microsoft.com/en-us/library/ms141209.aspx

share|improve this answer
add comment

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.