How to transfer a database from MySql to MS-SQL?

Question

I want to transfer my entire database from MySQL to the MS-Sql server.
although I am open to using any tool, I am forbidden to use only free avilable tools.

Answer 1

Use Microsoft SQL Server Migration Assistan (SSMA) for MySQL

• Microsoft SQL Server 2005 Migration Assistant for MySQL
• Microsoft Migration Assistant 2008 for MySQL

Answer 2

export db from MySql (mysqldump), manually edit to convert between SQL variants on two platforms, and then import into MS-SQL.