Convert MySQL script to MSSQL

Question

Hello,

I have a large MySQL set of commands in a file (script) and I need to execute it on a Microsoft SQL Server 2008. I know there are few differences in both languages, despite the fact the base SQL is the same.

Is there any way how to convert a MySQL script to one that is executable on MSSQL server? Or is there any migration app that can easily take the whole MySQL server and replicate everything on SQL Server 2008?

Thanks for any advice.

Answer 1

Try exporting into an ANSI SQL compliant format. Whatever data export utility you are using should provide you this option.

Answer 2

There are tons of conversion tools (free or commercial) out there, just google it.

The following one might be interesting for you as a programmer, it is free and comes with the codes: http://gathadams.com/2008/02/07/convert-mysql-to-ms-sql-server/

Answer 3

i heard that data loader is good, but i didn't used it yet.

Answer 4

Thanks a lot for answers. data loader seems good for me

Answer 5

I tried Full Convert Enterprise with quite big success. Fast, easy and it did my job. Give it a try it may help you