ON CALL DBA SUPPORT

— Database blog

Archive for February, 2012

Difference between GOLDEN GATE and STREAMS or GOLDEN GATE v/s STREAMS

Posted by ssgottik on 29/02/2012

SL NO

ORACLE  GOLDEN GATE

ORACLE STREAMS

1

Out of box flexible solution Requires  API based stored DB Packages

2

High performance in high transaction environment Problem scaling high throughput  environment

3

Broad heterogeneous support Works with only oracle database

4

Setup is very simple, need to download and untar/unzip the dump Need to execute the list of packages to setup streams

Posted in ORACLE GOLDEN GATE | Leave a Comment »