Home Forums SQL Server 2008 Working with Oracle How to make a solution real-time replicate from oracle and mysql to SQL server? RE: How to make a solution real-time replicate from oracle and mysql to SQL server?

  • May 23, 2013 at 9:05 pm

    #1618089

    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.