Oracle Streams vs Oracle Golden Gate
935140May 4 2012 — edited May 5 2012We are in the process of creating a reporting server (replica) for our production environments. I was considering Oracle streams and Oracle Golden Gate. I read a lot about both technologies and they both satisfy our demands for a reporting server.
I just want to know if anybody else had the same experience and what was the final choice and the rationale behind it?
Environment is as below:
First server Oracle Database 11.2.0.2.0 on Linux RH
Second Server Oracle Database 10.2.0.5.0 on Windows 2003
Both servers will live on Linux RH as a separate servers.