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 need to copy/migrate a database from MSSQL (SQL Server 2008) into MySQL. I am using the MySQL Workbench kit, and work through the process of the Migration. Each respective DB user has full access, the ODBC drivers are in place as well as the DSN.

It winds up copying the schemata successfully, but not any of the data. There are no errors or warnings (other than charset notices) and I am drawing blanks as to why data will not transfer over. There are not a lot of options in the migration steps, so I don't think I missed anything.

share|improve this question

2 Answers 2

According to the MySQL Documentation, the steps for the Migration Wizard should be

  1. Connecting to the databases
  2. Schemata Retrieval and Selection
  3. Reverse Engineering
  4. Object Selection
  5. Migration
  6. Manual Editing
  7. Target Creation Options
  8. Schema Creation
  9. Create Target Results
  10. Data Migration Setup
  11. Bulk Data Transfer
  12. Migration Report

Sounds like you got to Step 9. You have to make sure to setup Data Migration. Apparently, it is not automatic.

If you are having problems with the import, you are not alone. This has been a source of heartache for many. You may need to try :

share|improve this answer
    
I go through all 12 steps. The Report has a section called 'Data Copy' but is completely blank, unlike the rest of the report. Logs show no errors. –  Kevin Aug 21 '12 at 15:46
    
After the full object migration, there is the Data Transfer Setup. Under the Data Copy section of the Window, did you check Online copy of table data to target RDBMS or Create a batch file to copy the data at another time ? –  RolandoMySQLDBA Aug 21 '12 at 19:42
    
If you did the Live Transfer, please describe the Bulk Data Transfer: What did you see and how long did it take ??? –  RolandoMySQLDBA Aug 21 '12 at 19:49
    
Yes, Online Copy was ticked off. –  Kevin Aug 22 '12 at 12:51

It might be a bug. I ran into the same issue and found the following bug report in my search for a fix: http://bugs.mysql.com/bug.php?id=66516

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.