title: Porting MS SQL stored procedures to MySQL
body: <p>i have about 140 - 150 stored procedures that I need to migrate from MS SQL 2005 to MySQL 5.1</p>
  
  <p>After succesfully porting 0 of them in the last eight hours I decied to drop by and ask if anyone has any experience, or tips, or knows some util app that can help.</p>
  
  <p>MySQL Administrator is not very helpfull, with a frustrating "MySQL Error number 1064 You have an error  in your SQL Syntax; check the manual that corresponds to your MySQL server version for the right syntax". Given that an average SP is +100 lines long, simply GUESSING what the problem is is not an option.</p>
  
  <p>Eg.  This is the exact error that I get :</p>
  
  <pre><code>  Script line: 1    You have an error in your SQL syntax; check the manual that
     corresponds to your MySQL server version for the right syntax to use near '' at line 5
  </code></pre>
  
  <p>Then at line 5 all I have is:</p>
  
  <pre><code>declare PropID float;
  </code></pre>