Convert MySQL script to SQL Server [closed]

Question

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

Cremona

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: gathadams.com/2008/02/07/convert-mysql-to-ms-sql-server – Capitol

Previous suggestions to this problem can be found here: #2622182 – Greater

I have taken the source code from gathadams and improve it let me know if you need it ask me about DBscriptConverter – Putrefy

Answer 1

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

Foeman

Doesn't seem to convert the script but converts the database itself? – Delay

I downloaded this program (Trial) but it crashes when openning. – Anam

I used to use Version 5 without any problems, at least for my task. They have added a new tool sqltran.com. You may give it a try or contact them to help you. – Foeman

@MauricioGracia I can access the link – Trilbie

@MauricioGracia I also can access the link – Foeman

While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes. – Rapturous

@DaImTo in this case is a link to a Tool, I don't see what essential parts can be included of a download – Putrefy

@Trilbie yesterday when I posted the comment the page was down – Putrefy

this tools converts scripts or requires a database connection ? – Putrefy

It requires database connection, but upcoming version will also convert script dumps into live databases and vice versa. – Hyperopia

This tool is useless in regards to MySQL .dump files, as original poster has requested. – Manicdepressive