Home » Server Options » Replication » SQL Server software compatibility for Golden gate Replication (SQL Server 2008 R2 and Oracle 11g R2)
SQL Server software compatibility for Golden gate Replication [message #617627] Wed, 02 July 2014 06:07 Go to next message
chetankumar
Messages: 20
Registered: June 2014
Location: Dark Saturn
Junior Member
Hello

We want to replicate data from SQL Server 2008 R2 to Oracle 11g R2

Could you please let me know if "Standard Edition" of the SQL Server 2008 R2 supports the Golden gate replication

I googled and found that "only Enterprise edition supports golden gate replication" as "Standard Edition" does not have "Capture Functionality"

Thanks and Regards
Chetan


Re: SQL Server software compatibility for Golden gate Replication [message #617631 is a reply to message #617627] Wed, 02 July 2014 06:19 Go to previous messageGo to next message
John Watson
Messages: 8348
Registered: January 2010
Location: Global Village
Senior Member
I think that is correct: if you don't have EE, you can't use GoldenGate because it uses Streams technology for the capture. And you can't use Streams with SE.

You can do all the work on the SQL Server side by using the SQL Server Distributor, or do the work on the Oracle side by using heterogeneous services to run queries through a database link.
Re: SQL Server software compatibility for Golden gate Replication [message #617905 is a reply to message #617631] Fri, 04 July 2014 05:28 Go to previous message
chetankumar
Messages: 20
Registered: June 2014
Location: Dark Saturn
Junior Member
Hello John

Thank you so much for confirming it

Kind Regards
Chetan
Previous Topic: SQL Server to Oracle Replication - Golden gate - Checkpoint info and backup queries
Next Topic: Getting errors while using mixed versions of Golden Gate Software
Goto Forum:
  


Current Time: Mon Sep 28 05:25:36 CDT 2020