how to migrate DB from MySql to MS-SQL?

Question

i want to migrate my whole DB from MySQL to MS-Sql server.
though i am open to use any tool,am restricted to use only free avilable tools.

hallie · Accepted Answer · 2010-03-08 01:49:11Z

2

Use Microsoft SQL Server Migration Assistan (SSMA) for MySQL

answered Mar 5, 2010 at 8:01

hallie

2,83320 silver badges28 bronze badges

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

1 Comment

Thanx but,is this a version specific tool as am using version2008 and it was expecting version 2005

dar7yl · Accepted Answer · 2010-03-05 07:58:04Z

0

export db from MySql (mysqldump), edit by hand to convert between variations of SQL language in the two platforms, then import into MS-SQL.

answered Mar 5, 2010 at 7:58

dar7yl

3,78728 silver badges20 bronze badges

I guess you didn't detect my sarcasm :)