locked
Restore MySQL database file into SQL server RRS feed

  • Question

  • Hi experts,

    I have a MySQL Server backup file. How can I restore it to SQL Server?

    Or what is the way around getting the database into SQL Server?


    ebro

    Tuesday, May 27, 2014 7:19 PM

Answers

  • Shaky is right. You can't restore MySQL  backup file in SQL Server.

    But you can migrate the database from MySQL to Server using SSMA. Please refer the below link

    http://blogs.msdn.com/b/ssma/archive/2011/02/07/mysql-to-sql-server-migration-how-to-use-ssma.aspx

    http://msdn.microsoft.com/en-us/library/hh313125(v=sql.110).aspx

    http://www.youtube.com/watch?v=fXe4XL41jVE

    --Prashanth

    • Marked as answer by ebrolove Tuesday, May 27, 2014 7:57 PM
    Tuesday, May 27, 2014 7:34 PM

All replies

  • Hi experts,

    I have a MySQL Server backup file. How can I restore it to SQL Server?

    Or what is the way around getting the database into SQL Server?


    ebro

    You cannot restore MySQL backup file on SQL Server.

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it.

    My TechNet Wiki Articles

    Tuesday, May 27, 2014 7:28 PM
  • Shaky is right. You can't restore MySQL  backup file in SQL Server.

    But you can migrate the database from MySQL to Server using SSMA. Please refer the below link

    http://blogs.msdn.com/b/ssma/archive/2011/02/07/mysql-to-sql-server-migration-how-to-use-ssma.aspx

    http://msdn.microsoft.com/en-us/library/hh313125(v=sql.110).aspx

    http://www.youtube.com/watch?v=fXe4XL41jVE

    --Prashanth

    • Marked as answer by ebrolove Tuesday, May 27, 2014 7:57 PM
    Tuesday, May 27, 2014 7:34 PM