March 26, 2018 at 7:34 am
I've managed to get SQL Server Replication server working, replicating Oracle to Oracle. Have had it in production for a few weeks now.
I've only tested the following versions:
2014 and 2016
11gR2 and 12C
Write up is here: https://www.bus-hound.com/initial-setup/
March 26, 2018 at 2:46 pm
jeff.mcgettigan - Monday, March 26, 2018 7:34 AMI've managed to get SQL Server Replication server working, replicating Oracle to Oracle. Have had it in production for a few weeks now.I've only tested the following versions:
2014 and 2016
11gR2 and 12CWrite up is here: https://www.bus-hound.com/initial-setup/
Hi Jeff
I'm curious as to why someone would take this route given both SQL Server and Oracle have their own replication tools available.
Oracle's golden gate is pricey and they did get rid of streams in 12c but advanced replication(12.1) still exists.
March 26, 2018 at 2:56 pm
Hi Alex,
We have a large amount of SQL Server Enterprise licenses already, and do not wish to purchase more Oracle licenses. We also use the same replication server to replicate Oracle to Oracle, to replicate SQL Server to Oracle, and SQL Server to SQL Server. We are in the middle of culture transition so we need a lot of flexibility without commitment to more licensing. Streams performance is also not ideal for enterprise data movement in the volume we replicate.
Best,
Jeff
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply