Please tell me any of the below will work
can I write triggers on MS SQL server tables to update MySql whenever there is a transaction
OR
should I create a dummy table in MS SQL server and load it whenever there is a transaction on MS SQL server tables and using php script read the dummy table and update MySql database.
Thanks,
Shankar
shankar wrote:
Hi All,
I have 2 databases MS SQL server and MySql. I want to keep them in sync (every 1 hr or 1 day, I am not sure) i.e i want to update MySql Database for any event/transaction in MS SQL Server database. There r around 250 tables in MS SQL server. Please help me in this regard.
Thanx,
Shankar
