Convert from MySQL to SQL Server

[lah3233]

I'm new to MySQL(meaning I've never seen or used it before). What I'm wondering is if you can take a backup file from a MySQL database and attach it to SQL Server and have an up and running copy of the database file?

Can anyone out there answer this question or point me in the direction of some good documentation?

Thanks!

 

[sleipnir214]

What do you mean by "backup file from a MySQL database"?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[lah3233]

What I mean is if you back up the entire database as you would in SQL Server. Then can you take the .mdf file and import it into a SQL Server database? Or what is the proper steps to take to migrate a MySQL database to SQL Server??

Thanks!

 

[sleipnir214]

How are you backing up MySQL? There is no mechanism within the server to give you a .mdf file. MySQL and MSSQL use different database formats, and the one used by MSSQL is proprietary.

As I see it, you have two choices. Either use mysqldump (

http://www.mysql.com/doc/en/mysqldump.html)

to export your data to a set of SQL statements or use MySQL's SELECT...INTO <outfile> (

http://www.mysql.com/doc/en/SELECT.html)

to export your data to something like a CSV.

You can then import the data to MSSQL. The queries produced by mysqldump may need some tweaking to work right under MSSQL.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[lah3233]

Can you take a look at this link and tell me if something like this would be effective?

http://www.microsoft.com/technet/tr...prodtechnol/sql/deploy/upgrdmigrate/mysql.asp

I have never actually seen and/or used MySQL before - we just need to transfer the database from our client's system to ours. I was thinking that by looking at this article DTS would work great.

Please let me know.

Thanks!

 

[sleipnir214]

I can't answer. I don't have that much experience with SQL Server 2000. It looks like it could work, though. You're probably going to have to manually create the database and the tables on the MSSQL side, then use DTS to suck the data over.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[MKVAB]

Hello there. How did your migration go? I am in the process of doing the same. I used DTS packages to import the tables structure but when I did I lost a lot of the table attributes and some data types were changed. What method did you use? DTS? Did you end up manually altering the table strucutures once you got it into SQL Server?

-Mary Klaire

 

[lah3233]

Hi Mary

I ended up manually recreating table structures and then doing a dump to get the data moved over to SQL Server. DTS would not work for me as I didn't have the credentials that were needed to get into out client's MySQL database. Let me know if you have any further questions.