Restore Mssql bak file to Mysql 5.1 database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pradeep c
    New Member
    • Aug 2008
    • 8

    #1

    Restore Mssql bak file to Mysql 5.1 database

    Currently, I am having a backup file of MSSQL server 2005 database. I want to restore the backup file(of MS Sql server 2005) to MYSQL database.

    Please Note: I don't have MS sql server 2005 database.

    How can I do it?
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    As you can tell, those are different DBMSs with different syntax for their table definitions.

    Comment

    • Atli
      Recognized Expert Expert
      • Nov 2006
      • 5062

      #3
      My suggestion would be to set up a MSSQL database, restore the backup there, export the data into a CSV file and load that into MySQL.

      No good can come from trying to use a file formatted by a Microsoft product for anything other than what is was made for... even another Microsoft product.

      Comment

      Working...