Hii everyone,
I have a requirement that i need to transfer/retrive a table data from one database to one or more different database say from sqlserver to oracle and mysql.for example considering sqlserver as a source db and mysql&oracle db's as target db's present in remote server's,whenever i performed any operation(DDL&DML) on my source db table that should reflect to a perticular tables present in oracle&mysql automatically.
Can we do this with Replication?if yes how should i work with replication to meet my above requirement,anyone provide some guidence, what are the possible ways of achieving my above requirement,i.e wheather i should use stored procedure/triggers/cursors/need to schedule jobs?please also provide steps to connect to multiple databases present in remote servers from my local computer(sqlserver db),and try to suggest me which one is better suitable and results good performance.Please suggest me how should i go with this type of requirement.thanks in advance
Thanks
Ramu