Good tool for converting mssql queries to mysql queries

Question

I found alot of question on stack about converting mysql to mssql, but i would like to convert it otherwise.

From mssql server to mysql.

is there a (free) tool for this to do that without connecting to the databases? i have an sql query dump and i want to convert that by putting that code in an tool.

Thanks.

Answer 1

You're probably best off doing this yourself to ensure everything is correct rather than relying on a third party tool (Also the additional benefit of understanding the differences between the two pieces of code). However you could use this SQL to MySQL tool:

http://download.cnet.com/SQL-To-MySQL-Converter/3000-10254_4-75693763.html