Convert MySQL script to SQL Server

mysql sql sql-server-2008 code-migration
NumberFour picture NumberFour · Nov 20, 2009 · Viewed 42.3k times · Source

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.

Answer

ppolyzos picture ppolyzos · Jun 24, 2010

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

Related questions

Replace Default Null Values Returned From Left Outer Join

I have a Microsoft SQL Server 2008 query that returns data from three tables using a left outer join. Many times, there is no data in the second and third tables and so I get a null which I think is …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More