Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2009
    Posts
    1

    Unanswered: Communication between MS SQL and Mysql.

    Hi,
    I have 5 MS sql servers and one mysql server. All ms sql server are source database server where real time data are store and update. I need some selective column from all sql databases and have to store in mysql single database. Sql servers data are updating in time to time so i need to update mysql server database in a real time. If any one know how to do this please share me.

    Thanks.

  2. #2
    Join Date
    Apr 2008
    Location
    Iasi, Romania
    Posts
    561
    Provided Answers: 2
    You may use a MSSQL linked server to insert your data in MySQL from your MSSQL servers.
    Florin Aparaschivei
    DB2 9.7, 10.5 on Windows
    Iasi, Romania

  3. #3
    Join Date
    May 2012
    Posts
    1

    having similar issue now...

    Hi DipendraN, I'm running into similar situation now, what did you end up doing? Please, share...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •