Hi Gareth,

I worked with both of them.
Although Ingres Replicator , I found it more secure in terms of logins (how it connects to a database), it adds some burden on a heavy duty system. And it works with tables having primary keyes or unique indexes. The burden is on the locking system, and some significant impact on the Ingres DBMS server if say you would choose replication to happen once in a while and that would translate into massive data accumulated in the shadow tables.
HVR is more easy on the system load. But config files, do have on some instances, plain text password. However, I haven't seen locking issues, nor Ingres DBMS performance issues. I found tricky though it's Java interface.
The good side is that one could actually use tables without any unique constraints.
The bad side is for tables with big row width, at the configuration time it requires some significant resources, mainly QSF, QEF.
Another good part is that even if used it (HVR) once a day, for let's say about half of million records accumulated, no performance impact has been noticed, maybe say tops 2% degradation (worst case).

Overall I do think HVR is better.
Both of them share some principles and concepts.
If you look on both, both create rules and procedures on the originating Ingres database, and I could tell, HVR builds better ones.
A major point, HVR could use source / target combination either way you want it. And it doesn't need the gateways. Oracle I assume would be the same stuff, Oracle Net etc, but SQL Server for example, bye bye ODBC in HVR which I can tell you is a major bottleneck.

Armand

Hello all,

Sorry, I know we've touched on this in the past... but...

Other than HVR (promising) and Ingres Replication (which seems a shocking
bit of software), are there any other software vendors out there that'll
attempt to replicate - and work?

I'd really like to hear from people who have had good and bad experience
with the above or any type of replication.

(Ingres 2.6 on Solaris)

Thanks

Gareth Williams

-----------------------------------

Gareth Williams non-random quote #1: "Switch it off, then turn it back on"
English:- This message is confidential. If you are not the intended
recipient of the message then please notify the sender immediately. Any of
the statements or comments made above should be regarded as personal and not
necessarily those of Bro Morgannwg NHS Trust, any constituent part or
connected body. Cymraeg:- Mae'r neges hon yn gyfrinachol. Os nad chi yw'r
derbynnydd y bwriedid y neges ar ei gyfer, byddwch mor garedig ? rhoi gwybod
i'r anfonydd yn ddi-oed. Dylid ystyried unrhyw ddatganiadau neu sylwadau a
wneir uchod yn rhai personol, ac nid o angenrhaid yn rhai o eiddo
Ymddiriedolaeth GIG Bro Morgannwg, nac unrhyw ran gyfansoddol ohoni na
chorff cysylltiedig.

---------------------------------
Do you Yahoo!?
Free Pop-Up Blocker - Get it now