This content has been marked as final. Show 4 replies
I have no experience with Streams, but GG requires a separate license (which can be expensive), so your solution choice may come down to how much you are willing (or not) to spend.
Golden Gate is a “Strategic” replication solution, while Streams are in “Continue & Converge” mode -
http://www.oracle.com/technetwork/middleware/goldengate/overview/statement-of-direction-gg-132120.pdf (page 11).
I do not know what the practical impact of this policy is though.
Please refer below links
hope this helps,
You want to participate in Oracle Beta program or Exam?
Could Not Get DeploymentManager When Deploying or Undploying Agile
I have only used Streams, because if you are running on Enterprise Edition from the source side, then Streams is included in the database price, apply side can be standard edition also.
In Streams its very easy to exclude specific transactions from replication (using tags), i've heard its much more complex task in goldengate.
Streams can be a pain to set up, but when it is working, its working well.