The main difference between Oracle Stream and GoldenGate, aside from the extra licensing costs associated with GoldenGate, is the ease of setup, installation and configuration.
GoldenGate is geared more towards a heterogeneous environment, so it doesn’t depend on Oracle-specific items. Well, it does in one sense in terms of applying your own SQL statements in a call to SQLEXEC(). However, as far as relying on being able to access online redo logs, standby redo logs, or archived redo logs, no big deal. GoldenGate uses its own proprietary trail files (one set on the source and one on the target). It doesn’t care about Oracle Net Services either when it comes time to transport data from the source to the target.
Another way to compare Streams and GoldenGate is to think of coupling. Obviously, Streams would be considered to be tightly coupled with Oracle. GoldenGate, on the other hand, would be considered as being loosely coupled. Given that GoldenGate is Oracle Corporation’s strategic solution for at least replication and data integration, you can be sure that whatever is loose today won’t be nearly as much in the future.
From my perspective, the major differences of them are about “Cross Platform”
Golden Gate is using method of transferring open SQL text, that make it able to sync between Oracle to Oracle and with 3rd DB, like BD2 etc. it could be a DB migration tool.
Others are using Oracle redo tech, that limits them within Oracle environment
zhaos2
2 Intern
•
643 Posts
0
March 13th, 2012 01:00
The main difference between Oracle Stream and GoldenGate, aside from the extra licensing costs associated with GoldenGate, is the ease of setup, installation and configuration.
GoldenGate is geared more towards a heterogeneous environment, so it doesn’t depend on Oracle-specific items. Well, it does in one sense in terms of applying your own SQL statements in a call to SQLEXEC(). However, as far as relying on being able to access online redo logs, standby redo logs, or archived redo logs, no big deal. GoldenGate uses its own proprietary trail files (one set on the source and one on the target). It doesn’t care about Oracle Net Services either when it comes time to transport data from the source to the target.
Another way to compare Streams and GoldenGate is to think of coupling. Obviously, Streams would be considered to be tightly coupled with Oracle. GoldenGate, on the other hand, would be considered as being loosely coupled. Given that GoldenGate is Oracle Corporation’s strategic solution for at least replication and data integration, you can be sure that whatever is loose today won’t be nearly as much in the future.
reseach
2 Intern
•
225 Posts
0
March 14th, 2012 02:00
From my perspective, the major differences of them are about “Cross Platform”
Golden Gate is using method of transferring open SQL text, that make it able to sync between Oracle to Oracle and with 3rd DB, like BD2 etc. it could be a DB migration tool.
Others are using Oracle redo tech, that limits them within Oracle environment
Eddy