Migrating Sprocs from SQL Server 2k5 to MySQL 5.1

Question

Post reply

Migrating Sprocs from SQL Server 2k5 to MySQL 5.1

Sid Childers

Ten Centuries

Points: 1079
More actions
March 2, 2009 at 9:51 am

#128109

Good Morning & Happy Monday,
I have a database in SQL Server 2k5 that needs to be migrated to MySQL 5.1. There are over 190 sprocs in the current database. My understanding is that sproc syntax is different with MySQL. As such, can anyone provide me with a link to a syntax guide comparing SQL Server to MySQL sproc syntax?
Thanks,
Sid

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736063 More actions · Answer 1

http://searchenterpriselinux.techtarget.com/tip/0,289483,sid39_gci1207179,00.html\

http://www.isql.org/2007/02/mysql-vs-sybase-ms-sql-server.html

Sid Childers Ten Centuries Points: 1079 More actions · Answer 2

Thanks for these links. I reviewed them and am getting acquainted with the MySQL manual. There are over 190 sprocs to be converted. I'm using the MySQL Migration Toolkit and am having to manually edit each sproc to make it MySQL compatible. Are there any free, or moderately priced, tools that will make this a tad less painful?