January 27th, 2003, 07:46 PM
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?
January 28th, 2003, 03:05 AM
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.
January 28th, 2003, 06:54 AM
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.
January 28th, 2003, 08:21 AM
Use triggers in SQLServer
January 28th, 2003, 09:34 AM
Which database is the master and which is the slave?
January 28th, 2003, 10:52 AM
There is no master/slave relationship. The exchange of data needs to be 2 way, thoughnot the same data elements.
January 28th, 2003, 11:20 PM
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?