How to dump a database from mysql to Sql Server2005

Hi Every bdy,

I have a database which is in mysql. Now we want to port that database to Sql Server 2005. Please tell the steps to do this.

With Regards

Ravinder Reddy.K

Two options. One, use a DataReader Source to use the MySQL ODBC driver to connect to your database and the do whatever you wish to do with the data from there.

Two, you can use mysqldump to export the database to a text file, and from there you might be able to simply run the resulting SQL, correcting a few datatypes along the way to match SQL Server's.

|||need more explanation about using a datareader|||Create an ODBC connection to your MySQL database. In your data flow, drag a DataReader Source component onto the background. Double click on it and go from there. You'll need to pick the ODBC driver, and then specify the name of the MySQL connection (DSN) you created earlier.|||Sorry for dragging. You mentioned that "In your data flow" what is it. please give more explanation|||

Do you have any experience in SQL Server Integration Services?

Tutorials: http://msdn2.microsoft.com/en-us/library/ms167031.aspx

|||

Hold on....

How many records are in your MYSQL database? The answer will determine what method you use to import the data.

Small database - (<20 million rows). Create ODBC connection to MySql and use the DataReader to read data. Load directly into a SQL Server destination.

Large database (>20 million rows). My recommendation is to do #1 above, but output to a raw file format. Create a second DataFlow that reads from the raw file and loads to a SQL Server destination. This adds a safety valve against connectivity disruptions.

Do you need any more help?