SQL Server to mySQL converter

Question

Hai Techies,

I have some stored procedure which was written in SQL server.Now i want to migrate this to mysql.Is there any freeware tools which can do this for me.

Answer 1

I don't think so. You could just execute the query to create the procedure, ie:

CREATE PROCEDURE Blah(foo int, bar text)

END;

(I think) and then ask questions or Google any problems that occur.

Answer 2

There is a toolkit for data migration, available at this link, but you might have to handle stored procedures manually. Another suggestion, that if you can find a conversion tool to move the SP's to DB2 you may have an easier time, as MySQL procedures are close to DB2 in style.