Jo Pattyn (5/23/2013)
Have no experience with realtime replication. How realtime is it (ns, ms, minutes...). Is it realtime part oneway (oracle+msql) to ms sql server?
Triggers have a disadvantages
They need MS SQL to generate report from multisource such as MySQL and ORacle. It's one way replication. Normally, i've seen from GoldenGate but the interesting story's using MS SQL. Microsoft guy used to tell me about replication from Oracle to MS SQL, 's simple by DTS.