How to make a solution real-time replicate from oracle and mysql to SQL server?

  • Anyone have experience like this please share, my company need to reduce licensing of oracle. thank you

  • 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

  • krit (5/23/2013)


    Anyone have experience like this please share, my company need to reduce licensing of oracle. thank you

    This is really funny, just a couple of days ago somebody mentioned SymmetricDS as a viable solution when talking about heterogeneous replication.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • krit (5/23/2013)


    Anyone have experience like this please share, my company need to reduce licensing of oracle. thank you

    I don't see how real time replication of data from an Oracle Server to and SQL Server is going to do that. If you want to reduce licensing of Oracle, you'll need to physically cut down on Oracle Servers. That means a migration of apps from Oracle to SQL Server.

    --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)

  • 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.

  • PaulB-TheOneAndOnly (5/23/2013)


    krit (5/23/2013)


    Anyone have experience like this please share, my company need to reduce licensing of oracle. thank you

    This is really funny, just a couple of days ago somebody mentioned SymmetricDS as a viable solution when talking about heterogeneous replication.

    Interesting Symmetricds !! Thank you for key word.

  • Jeff Moden (5/23/2013)


    krit (5/23/2013)


    Anyone have experience like this please share, my company need to reduce licensing of oracle. thank you

    I don't see how real time replication of data from an Oracle Server to and SQL Server is going to do that. If you want to reduce licensing of Oracle, you'll need to physically cut down on Oracle Servers. That means a migration of apps from Oracle to SQL Server.

    Thank you for comment, but political in ORG plays an important role for big change.

  • 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)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply