Convert MySQL script to SQL Server

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.

There are tons of conversion tools (free or commercial) out there, just [google it](http://www.google.com/search?q=mysql+to+mssql+conversion). 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/ — o.k.w, Nov 20 '09 at 14:42
Previous suggestions to this problem can be found here: http://stackoverflow.com/questions/2621682/import-mysql-database-into-a-ms-sql-server — WernerW, Apr 03 '13 at 11:17
I have taken the source code from gathadams and improve it let me know if you need it ask me about `DBscriptConverter` — Mauricio Gracia Gutierrez, Jul 08 '15 at 07:11

score 4 · Answer 1 · answered Jun 24 '10 at 20:47

4

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

answered Jun 24 '10 at 20:47

ppolyzos

6,791
6
31
40

1

Doesn't seem to convert the script but converts the database itself? – user2019515 Mar 12 '13 at 18:59
I downloaded this program (Trial) but it crashes when openning. – Totalys Nov 21 '13 at 20:09
I used to use Version 5 without any problems, at least for my task. They have added a new tool http://www.sqltran.com/. You may give it a try or contact them to help you. – ppolyzos Jan 23 '14 at 16:18
@MauricioGracia I can access the link – vusan Jul 08 '15 at 08:45
@MauricioGracia I also can access the link – ppolyzos Jul 08 '15 at 08:51
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. – Linda Lawton - DaImTo Jul 08 '15 at 09:16
@DaImTo in this case is a link to a Tool, I don't see what essential parts can be included of a download – Mauricio Gracia Gutierrez Jul 08 '15 at 13:36
@vusan yesterday when I posted the comment the page was down – Mauricio Gracia Gutierrez Jul 08 '15 at 16:34
this tools converts scripts or requires a database connection ? – Mauricio Gracia Gutierrez Jul 08 '15 at 16:36
It requires database connection, but upcoming version will also convert script dumps into live databases and vice versa. – Damir Bulic Jul 26 '15 at 19:06
This tool is useless in regards to MySQL .dump files, as original poster has requested. – Alex Cherkasov Jan 08 '16 at 02:16

Convert MySQL script to SQL Server

1 Answers1

Linked

Related