1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to Import Data in MySql from MS SQL SERVER (Very Easiy)

Discussion in 'Bing' started by YaseenGhanchi, May 2, 2012.

0
  1. #1
    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.

    This is my All Time first Post.
    Hope you Like it

    Regards:
    Mohammad Yaseen Ghanchi
     
    YaseenGhanchi, May 2, 2012 IP
  2. Wesley T

    Wesley T Peon

    Messages:
    48
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Nice tutorial.

    But should this be posted in the programming section?
     
    Wesley T, May 3, 2012 IP