Convert T-SQL to MySQL

Question

Is there an easy way to convert Transact-SQL to MySQL?

---

I am attempting to convert a database archive of stock ticker symbols and company names.

Answer 1

The short answer: NO

The medium answer: MAYBE

The long answer: That depends on what's in your TSQL and how much time and effort you want to put into it.

TSQL is not a subset of MySQL's dialect. So there exists some TSQL for which there is no MySQL conversion. However, the overlap between the two languages is pretty significant, and to a certain degree the conversion is just a matter of syntax.

This isn't a new problem, and some people have tried to tackle it. A quick google search for "tsql to mysql" yields some promising results, notably this project here, which attempts to convert stored procedures from TSQL to MySQL:

http://sourceforge.net/projects/tsql2mysql/

This probably won't solve your problem completely, but it's at least a start.

Answer 2

This website converts to/from many sql database versions: http://www.sqlines.com/online

TSQL, MySql, Oracle, DB2, Sybase, Informix, Hive, MariaDB, PostgreSQL, RedShift, TeraData, Greenplum, Netezza