Mysql – How to migrate from MySQL to SQL Server 2008

migrationMySQLsql serversql-server-2008

I have MySQL database backup file (Mysql version 5.1)
and i want to restore it in Sqlserver 2008 how do i restore it?

Best Answer

You can't restore a MySQL backup into SQLServer 2008 automatically. You can write a conversion script to convert the data, or use a tool like Microsoft DTS (called SQL Server Integration Services nowadays).