I need to convert my Mysql database to SQL Server 2005 database, Is there any tools available for this conversion.
Asked
Active
Viewed 468 times
2

marc_s
- 732,580
- 175
- 1,330
- 1,459

Ayyappan Anbalagan
- 11,022
- 17
- 64
- 94
-
Here's a description of [how to accomplish this](http://studentclub.ro/lucians_weblog/archive/2007/04/30/migrate-from-mysql-to-ms-sql-server-2005-express-edition.aspx). I can't speak as to how safe or well this works. – Jeff Swensen May 06 '10 at 16:26
-
literally the 2rd link down from my url... which is why I posted, the url... – dlamotte May 06 '10 at 16:37
1 Answers
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).

Community
- 1
- 1

Tomislav Nakic-Alfirevic
- 10,017
- 5
- 38
- 51