Translate SQL to MySQL

Can anyone recommend a good and free tool to translate Ms SQL scripts to MySQL?

Thanks
Dani
LVL 9
daniel_ballaAsked:
Who is Participating?
 
RichardCorrieConnect With a Mentor Commented:
you can download the MySQL convertion kit from the Mysql site (www.mysql.com) for free.

I have used it to script the tables etc.  Unfortunately it will only "convert" the most simple to Stored procedures etc; ie standard Select staements.  

If you use MSSQL (ie non ansi standard) keyword (eg @@Identity or set Nocount on) it will not convert the sp. it will, however add it to the script file, commented out, and you can make the required changes before running on the Mysql machine.

I would reccomend installin MySQL on your local mahine first (it is free!!) to test and modify....

/Richard
0
 
HuyBDCommented:
you mean convert

You can export from Enterpise manager of MSSQL via ODBC

note; create DNS of MySQL first
0
 
daniel_ballaAuthor Commented:
I need something a bit more difficult.
The real issue is that my host supports ASP.NET but doesn't have MsSQL, only MySQL. So what I was after was an easy way to deploy my projects which means that I have to create the databases on the remote MySQL server (where I only have access through a web-based control panel).
So my plan was to generate the database sql script (from enterprise manager), then find some tool to translate it to MySQL (all the minor differences) and then run that script on the web control panel. Does this make sense?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
adatheladCommented:
Hi,

Perhaps this may help:
http://www.programurl.com/mssql-lt-gt-mysql-converter.htm

Haven't tried it myself, and tbh I'm not sure if there is something that will (reliably/completely) do what you want.
0
 
daniel_ballaAuthor Commented:
Will try and I'll post back the results
thanks
0
 
daniel_ballaAuthor Commented:
Tried it, but it doesn't work at script level ... actually I don't see it being any better than HuyBD's solution using Enterprise manager of MSSQL.
Any other ideas?

Could it maybe .... if I do export it to MySQL is there any MySQL tool (like the MsSQL Enterprise manager) that would generate the script from the database itself?
0
 
daniel_ballaAuthor Commented:
No other ideas?

Hmmmm.... so that's why hosting without MsSQL server is cheaper :)
0
 
daniel_ballaAuthor Commented:
Thanks Richard, that sounds doable.
I guess this is as good as it gets.

Cheers
Dani
0
 
daniel_ballaAuthor Commented:
Sorry to be think Richard, but could you point me to that MySQL convertion kit? I've been searching for it but couldn't fnd it
0
 
daniel_ballaAuthor Commented:
Sorry to be thick Richard, but could you point me to that MySQL convertion kit? I've been searching for it but couldn't fnd it
0
 
RichardCorrieCommented:
0
 
daniel_ballaAuthor Commented:
Thank you!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.