Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to make a solution real-time replicate from oracle and mysql to SQL server? Expand / Collapse
Author
Message
Posted Thursday, May 23, 2013 9:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 22, 2013 11:31 AM
Points: 4, Visits: 10
Anyone have experience like this please share, my company need to reduce licensing of oracle. thank you
Post #1456055
Posted Thursday, May 23, 2013 10:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:10 AM
Points: 1,386, Visits: 6,244
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
Post #1456077
Posted Thursday, May 23, 2013 12:32 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
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.
Post #1456165
Posted Thursday, May 23, 2013 6:31 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:14 AM
Points: 36,735, Visits: 31,186
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1456265
Posted Thursday, May 23, 2013 9:05 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 22, 2013 11:31 AM
Points: 4, Visits: 10
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.

Post #1456279
Posted Thursday, May 23, 2013 9:09 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 22, 2013 11:31 AM
Points: 4, Visits: 10
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.
Post #1456280
Posted Thursday, May 23, 2013 9:14 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 22, 2013 11:31 AM
Points: 4, Visits: 10
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.
Post #1456282
Posted Friday, May 24, 2013 4:05 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:14 AM
Points: 36,735, Visits: 31,186
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #1456710
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse