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.

Here's a description of how to accomplish this. I can't speak as to how safe or well this works. — Jeff Swensen
– Jeff Swensen, Commented May 6, 2010 at 16:26

Community · Accepted Answer · 2017-05-23 10:27:52Z

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

edited May 23, 2017 at 10:27

CommunityBot

11 silver badge

answered May 6, 2010 at 16:47

Tomislav Nakic-Alfirevic

10.2k5 gold badges42 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

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

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related