How can i convert a Mysql database to MSsql?

Portal Home > Knowledgebase > Articles Database > How can i convert a Mysql database to MSsql?

Posted by kingofss, 12-28-2010, 05:29 AM
Hi Guys, Can you give me some advice on converting a mysql data to mssql data? I heard that some programs exists but not sure. When it is converted, does it work fine? Thanks
Posted by instantIT, 12-28-2010, 05:47 AM
You are converting which version of MySQL to which version of MSSQL? You might need to specify as the data engine running for conversion only application to specific version.
Posted by kingofss, 12-28-2010, 05:56 AM
Oh sorry. I will check it out and inform you. Thanks
Posted by DxSEO, 12-28-2010, 08:01 AM
either you can use third party tool to convert or you can generate sql script and paste in query manager to execute it
Posted by iTom, 12-28-2010, 10:35 AM
I have made a PHP script to do it in the past, its not too hard... There are probably better, may be even easier ways of doing it though.
Posted by centauricw, 12-30-2010, 02:53 AM
One word of warning. MS SQL Server is not case-sensitive for database/column names while MySQL is.