Wednesday, May 22, 2013

How to Import Data in MySql from MS SQL SERVER


I have a very good and Easy Steps for import Data in MySql from MS SQL Server.

1.) First of All You have to open Visual Studio 2010.

2.) Go to Server Explorer.

3.) Add a New Connection of MySql.

4.) Add Database which you want to import Data From SQL Server Db.

5.) Add another Connection of MS SQL Server.

6.) Add Database which you want to Export Data for MySql.

7.) Now you have Opened both Databases in Server Explorer of Visual Studio 2010.

8.) Now Right Click on Table (which you want to copy data to MySql) and click on SHOW TABLE DATA.

9.) Now Select All data from your table and Copy that records.

10.) Now Open MySql Database and open same Table (which you want to paste data into) from MySql and Paste all Data you copied from MS SQL SERVER.

No comments:

Post a Comment