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

Question

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

krit

Old Hand

Points: 316
More actions
May 23, 2013 at 9:27 am

#277805

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

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

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

Jo Pattyn SSC-Dedicated Points: 32347 More actions · Answer 1

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

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 2

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.

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 3

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)

krit Old Hand Points: 316 More actions · Answer 4

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.

krit Old Hand Points: 316 More actions · Answer 5

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.

krit Old Hand Points: 316 More actions · Answer 6

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.

Jeff Moden SSC Guru Points: 1004340 More actions · Answer 7

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)