Hello all,
Is there any way to converting MySQL to Microsoft SQL?
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.