18

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.

Improve this question
3
  • 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 Commented Nov 20, 2009 at 14:42
  • Previous suggestions to this problem can be found here: stackoverflow.com/questions/2621682/… Commented Apr 3, 2013 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 Commented Jul 8, 2015 at 7:11

1 Answer 1

Reset to default
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

Improve this answer
Sign up to request clarification or add additional context in comments.

11 Comments

Doesn't seem to convert the script but converts the database itself?
I downloaded this program (Trial) but it crashes when openning.
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.
@MauricioGracia I can access the link
@MauricioGracia I also can access the link
|

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.