SQLTeam.com | Weblogs | Forums

Convert MySQL to MSSQL

Hello all,

Is there any way to converting MySQL to Microsoft SQL?

If you are asking if there is a way to convert a MySQL database to an MS SQL server database, not a completely automated way. If your MySQL database has stored procedures, functions or views, you will need to re-write them for SQL Server. You can import the tables using SSIS but you will need to add the constraints and primary/unique keys.

All depends from what exactly database objects you need to convert automatically. If tables, indexes, foreign keys and views then try DBConvert for MSSQL & MySQL. Data will be moved too.
Conversion of stored procedures is not supported.