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 0 down vote favorite

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

migrated from stackoverflow.com Feb 27 at 18:15

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

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