#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2003
    Posts
    6
    Rep Power
    0

    MS sql v7.0 exchange data with mysql


    I have a web app that runs in 1 domain under both linux/apache/php and mysql as well as NT4.0/IIS/ASP/COM/MS SQL 7.0. I am trying to get information to exchange between the 2 environements.
    Does anyone know of any tools available?
  2. #2
  3. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
    You can use DTS with MyODBC driver, to send data from SQLServer to MySQL.
    Or you can schedule an extraction to flat file from MySQL and then load data into SQLServer.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2003
    Posts
    6
    Rep Power
    0
    Thanks for the options, but this has to be real time transactional exhange of data. I have up to 5 seconds max for this to occur.
  6. #4
  7. Modding: Oracle MsSQL Firebird
    Devshed Supreme Being (6500+ posts)

    Join Date
    Jun 2001
    Location
    Outside US
    Posts
    8,527
    Rep Power
    538
  8. #5
  9. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    Which database is the master and which is the slave?
    El éxito consiste en una serie de pequeñas victorias día a día

    MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html
  10. #6
  11. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2003
    Posts
    6
    Rep Power
    0
    There is no master/slave relationship. The exchange of data needs to be 2 way, thoughnot the same data elements.
  12. #7
  13. No Profile Picture
    Contributing User
    Devshed Regular (2000 - 2499 posts)

    Join Date
    Jan 2003
    Location
    No es importante
    Posts
    2,065
    Rep Power
    14
    Two way data exchange? Is the data exchange between the same tables? If so this is very dangerous and can lead to data corruption.
    ...
    What is your layout and your goal?
    El éxito consiste en una serie de pequeñas victorias día a día

    MySQL, MS SQL, MS ACCESS, Oracle Database Manager - http://victorpendleton.net/products/psdviewer.html

IMN logo majestic logo threadwatch logo seochat tools logo