I need to convert my Mysql database to SQL Server 2005 database

Question

I need to convert my Mysql database to SQL Server 2005 database, Is there any tools available for this conversion.

Answer 1

Here's a description of how to accomplish this. I can't speak as to how safe or well this works.

Answer 2

I will suggest a generic, standards-based, platform-independent approach, applicable to any two databases. Taken streight from an answer to another question, you can use any of the following tools:

• SQL Workbench, using the WbCopy command
• an ETL tool, like Pentaho Data Integration
• DDLUtils

All of these will allow you to tweak the migration process to some degree (e.g. batch size).