Connecting Tech Pros Worldwide Help | Site Map

Restore Mssql bak file to Mysql 5.1 database

 
LinkBack Thread Tools Search this Thread
  #1  
Old October 31st, 2008, 12:15 PM
Newbie
 
Join Date: Aug 2008
Posts: 8
Default 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?
Reply
  #2  
Old October 31st, 2008, 12:58 PM
Administrator
 
Join Date: Sep 2006
Posts: 11,940
Default

As you can tell, those are different DBMSs with different syntax for their table definitions.
Reply
  #3  
Old November 1st, 2008, 01:49 AM
Atli's Avatar
Moderator
 
Join Date: Nov 2006
Location: Iceland
Age: 22
Posts: 3,523
Default

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.
Reply
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search


Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,662 network members.