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 24, 2013 at 4:05 pm

    #1618460

    krit (5/23/2013)

    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.

    Ok, and understood but what does that have to do with reducing licensing of Oracle Servers like you asked?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)