SQL Server to MySQL - but what to do with sprocs?

Question

I have been tasked with converting a SQL Server database into a MySQL 5.* database. I feel well-read up about converting between datatypes.

However, I read that MySQL does ANSI, not T-SQL, and doesn't support cursors. My question is, what am I supposed to do with all of my SQL Server functions and sprocs (some of which use cursors) ?

I want to "do it the right way" .

Do I move them all to code like SqlCommand cmd = new SqlCommand("SELECT * FROM ...", con");, do I move them to MySQL's procedure-things, should I try jQuery, or LINQ, or ... ?

The front end will be in ASP.NET still, but there is a possibility we might rewrite/move it to PHP.

Answer 1

I don't think jQuery is going to help, but you may be able to do without the SPROCS entirely if you move to LINQ. Since I started using LINQ as my (lightweight) ORM, I rarely use an SPROC.

Answer 2

if cursors are your big hang-up, you can loop without a cursor:

http://stackoverflow.com/questions/935336/sql-server-cursor-reference-syntax-etc/935367#935367

MySql has a WHILE loop:

http://dev.mysql.com/doc/refman/5.0/en/while-statement.html

just select the MIN(PK) and loop over the set SELECTing the MIN(PK)>currentPK that meets your WHERE clause.