Database Software

Hi Guys,

I am in a situation to choose a replication product between Oracle Streams and GoldenGate. I looked at very old posts in the forum but did not conclude any solid information unfortunately.

Now we are using SharePlex for quite a while. As the development and support stopped for this product and we are not completely satisfied with this, we are looking for alternatives.

I tested Streams for 2 months and found it interesting. The main problem I noticed for us is, there is no table compare and/or sync mechanism in Streams. If some conflicting updates occurs, we would have to manually handle it (There are handlers but will require lot more effort to write for all the tables).

For a week, I have started evaluating GoldenGate replication software. I might be biased to Streams. That's why asking your assistance and want to know your thoughts.

The main problems I noticed so far for GoldenGate are -

1. It does not speak in oracle or SQL language - it has it's own languages. It has it's own command, error code which is not SQLs or is not similar to it.

2. The errors that are reported - are not well documented and not well understood always.

3. The user has to configure lots of things to smoothen the whole process. Where Streams is handling many stuffs by default.

4. If for any conflicting updates (same row is updated in two database simultaneously) and the tables got unsync, I cann't apply the errors (retry transactions) while it is possible in streams.

5. GoldenGate is not supporting SNMP while Streams has Metric in Enterprise Manager which could be used to monitor things.

So, if you know the advantages and drawbacks - please share.

Thank you very much.