up vote 1 down vote favorite
share [g+] share [fb]

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.

Thanks.

link|improve this question
40% accept rate
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. – Richard 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
feedback

1 Answer

up vote 1 down vote

Document specificly addressing mysql to mssql 2005: http://download.microsoft.com/download/e/c/8/ec8d5025-7ef7-4dcc-a9f3-9c297cf5350e/MigrateMySQLtoSQLServer.docx

White papers on migration: http://www.microsoft.com/downloads/details.aspx?familyid=3f0f2a3f-dff9-49cd-8ea7-581aa7a303a4&displaylang=en&tm

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. "

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.