Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I found the following tool to convert a MySQL database to MSSQL. We want to know if there is anything else available to do this before we go buying products.

We tried

mysqldump --compatible=mssql --result-file=dbname_mssql.sql dbname

no luck. Any ideas?

share|improve this question
    
similar discussion serverfault.com/questions/44230/… –  Troggy Jul 30 '09 at 19:47

2 Answers 2

If you have MSSQL Development edition or higher you already have the tool for you needs!

Checkout This Post on how to use SSIS with MySQL and SQL Server. You can then use the data flow to manipulate the data from one server/table to another.

And of course see this Stack Overflow discussion :)

Hope this helps.

share|improve this answer

For simplier databases and a bit of manual work, you can dump mysql as CSV and then import into SQL Server using select ... outfile.

There is also a tool on code project that apparently does this (I haven't verified whether it works).

Microsoft has a guide (from 2001, so it's a bit dated) about migrating from MySQL to SQL Server 2000.

share|improve this answer

Your Answer

 
discard

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.