Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.



migration rejected from Jan 24 '15 at 10:04

This question came from our site for system and network administrators. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as off-topic by Paul White, Phil, RolandoMySQLDBA, RLF, Michael Green Jan 24 '15 at 10:04

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope." – Paul White, Phil, RolandoMySQLDBA, RLF, Michael Green
If this question can be reworded to fit the rules in the help center, please edit the question.

up vote 2 down vote accepted

Have you looked at the SQL Server Migration Assistant for MySQL tool yet?

Added: Looks like this tool will do it for you:

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.