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 have a SQL Server DB. I want to migrate that DB to MySQL. In my SQL Server DB, some tables has about 50,000 to 1,00,000 records. I am trying to migrate the DB by DB migration tool embedded in MySQL Workbench. But in this process it is taking too much time. After 15 hours I cannot see any significant improvement in data transfer. So, is there any other process to make the DB migration or any other open source tool which can give better output?

Please suggest.

share|improve this question

migrated from stackoverflow.com Feb 27 '13 at 18:15

This question came from our site for professional and enthusiast programmers.

2  
How many tables, and how much data (size on disk) are you talking about here? –  Jon Seigel Feb 27 '13 at 18:23
    
Have you tried the standard tricks, like disabling indexes, using multiple-row inserts, etc? –  Alain Collins Mar 6 '13 at 17:03

Your Answer

 
discard

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