Tool to Convert MySQL DB to MS SQL 2005 (Especially stored procedures)

Question

Is there any tool to convert MySql db to MS SQL 2005.

I am mostly interested in converting Stored Procedures. There are 100s of procedures and writing them again in T-SQL is a big job.

Thanks.

SQLChicken · Accepted Answer · 2011-06-28 15:39:19Z

up vote 2 down vote accepted

Have you looked at the SQL Server Migration Assistant for MySQL tool yet? http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=14280

edited Jun 28 '11 at 15:39

answered Jun 28 '11 at 11:13

SQLChicken
35614

	I should also add, this tool converts schemas. Objects will still need hand-coding as it won't convert ANSI SQL to T-SQL on its own. – SQLChicken Jun 28 '11 at 11:31
	thanks. The first link is not working. – Kashif Jun 28 '11 at 14:16
	@Muhammad, thanks for heads up, I've fixed the link – SQLChicken Jun 28 '11 at 15:39
	I am so greatfull that you spare time to help me. It worked. – Kashif Jun 30 '11 at 5:55

migrated from serverfault.com Jun 27 '11 at 22:00