Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

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

I have a MySql database (tables + data) I wish to move to a Sql Server 2005 database keeping data intact (I know there will be some minor differences in data types).

I'm looking for any tutorial, tool, article that will help me with this.


share|improve this question
up vote 0 down vote accepted

Begin with Microsoft's guide for migration: Migrating to SQL Server 2008 , and then look at Microsoft's specific guide for mySQL to SQL Server: Guide to Migrating from MySQL to SQL Server 2008

share|improve this answer
Thanks, it didn't work because it's SQL Server 2005. I updated my question – Pierre Dec 2 '10 at 13:07
Ok thanks to your link I found another one that just did it:… – Pierre Dec 2 '10 at 13:22

Your Answer


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