i wanted to know how to syncronize the data from oracle 8/8i to mssql server 7.0 ...
the problem here is each and every dml activity(insert,update,delete )should be replicated to mssql server tables.
and mssql server dml activity should be replicated to oracle tables.
at certain time interval automatically.
right now i am thinking to capture the data in xml file and push the data to other database...
if there is any logic which will solve the problem very easily..any related website please tell me....
thanks in advance
I think you could user MYSQLDMP feature as well to capture
the required data (mysqldmp generates INSERT statements)
and run this script file to load into Oracle. You could automate this process using CRONTAB.
Click Here to Expand Forum to Full Width