Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

The ultimate goal in this task to to take a complete database in MySQL and export it to MSSQL. I was hoping to be able to do this with mysqldump.


share|improve this question
Can you assure that there will be no data changes to the MySQL DB for the duration of the export? That opens up a lot of options. – Bruno Bronosky Jul 23 '09 at 15:22
Yes. Nothing will be changed on the MySQL database. Thanks for your comment. – Geo Jul 23 '09 at 19:55

Document specificly addressing mysql to mssql 2005:

White papers on migration:

This references mssql 2005, but should be very useful information and it is directly from microsoft.

There is a tool in mssql for major database migrations but, "Note: A Migration Assistant for migrating from MySQL to SQL Server is not available yet. "

share|improve this answer

Your Answer


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.