MSSQL stored procedures to inline mySQL

[ashaig]

I have about 50 stored procedures in a intranet application which I want to convert to MySQL. There are plenty of products to convert the data, but nothing for SPs.
Does anyone know of a <b>guide</b> for undertaking this mammoth task? Some of the SPs are quite 'procedural' IE. use conditional statements &quot;IF&quot;, &quot;ELSE&quot;, &quot;BEGIN&quot;, &quot;END&quot; - also cursors.
I can generate a script file of the SPs from MSSQL which will give me quick access to the code, but I don't expect to just be able to cut 'n paste into MySQL.
If someone has done this kind of thing before I would be grateful for tips, pitfalls to watch out for etc.

Thanks

 

[QatQat]

SP are not supported in MySQL until vers 5.0 although you can re-write something which will do pretty much the same using MySQL transaction with InnoDB tables.

However not everything that can be done in MSSQL can also be done in MySQL and I am no aware of any tool which will convert totally or partially you SP.

You can find out about MySQL capabilities at MySQL home site and InnoDB transaction at

http://www.innodb.com

Bye

Qatqat

The reason why my girlfriend can read my thoughts is because mine are properly written! (G.Lepore)