Connecting Tech Pros Worldwide Help | Site Map
bytes > topic > mysql > answers

Restore Mssql bak file to Mysql 5.1 database

  #1  
Old October 31st, 2008, 01:15 PM
Newbie
  
Join Date: Aug 2008
Posts: 8
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?
  #2  
Old October 31st, 2008, 01:58 PM
Lives Here
  
Join Date: Sep 2006
Posts: 12,084

re: Restore Mssql bak file to Mysql 5.1 database

As you can tell, those are different DBMSs with different syntax for their table definitions.
  #3  
Old November 1st, 2008, 02:49 AM
Atli's Avatar
Moderator
  
Join Date: Nov 2006
Location: Iceland
Posts: 3,701
Provided Answers: 4

re: Restore Mssql bak file to Mysql 5.1 database

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

« previous question | next question »

/bytes/development

/bytes/it

/bytes/about

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 225,698 network members.

dev questions:
algorithms | asp | asp.net | c/c++ | coldfusion | c# | flash | html/css | java | javascript |
mobile dev | .net | perl | php | python | ruby | software dev | vb.net | visual basic | xml
it questions:
access | apache | careers | db2 | iis | macosx | mysql | networking | oracle | postgresql | sql server | unix | windows

About Bytes | Copyright 1995-2009 BYTES. All rights Reserved