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

Restore Mssql bak file to Mysql 5.1 database

Newbie
  
Join Date: Aug 2008
Posts: 8
#1: Oct 31 '08
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?

Lives Here
  
Join Date: Sep 2006
Posts: 12,070
#2: Oct 31 '08

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.
Atli's Avatar
Moderator
  
Join Date: Nov 2006
Location: Iceland
Posts: 3,752
#3: Nov 1 '08

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 »

Similar MySQL Database bytes

/bytes/development

/bytes/it

Forums
Visit our community forums for general discussions and latest on Bytes

Our staff and community areas have moved to bytes.com/forums/

/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 226,471 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