Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

share

migration rejected from serverfault.com Jan 24 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 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.

1 Answer 1

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

Added: Looks like this tool will do it for you: http://www.ispirer.com/products/mysql-to-sql-server-migration

share
    
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.