Our client has an Ingres 2.6 database and an OpenROAD 4.1 application

Rather than do a complete upgrade for all users, they want to create
an Ingres 2006 (or Ingres 9.2) database and run the OpenROAD 2006
version of the same application on that for just a subset of users for
now

However they DO want to keep some tables in both these databases in
sync

I assume Replicator is the product for this - is it easy to use, does
it work properly, what are peoples opinions, or is there a better tool/
method out there ?

Colin Hay

Colin Hay wrote:

I don't understand precisely what you want to get out of this exercise,
but perhaps Star is a better option? There are significant limitations
to the SQL you can use through Star, but setting up a replication scheme
is no walk in the park.

--
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
Go to http://www.iua.org.uk/join to get on the mailing list.

Hi Colin,

If you asked me what was the worst product in the Ingres area I would say Replicator...It sucks big time. You'll find its very possible and almost certain for a single user to do an insert and deadlock themselves. If you have to replicate then find another product. HVR comes to mind.

In this case though it sounds like you can probably achieve what you want through STAR. Create a distributed database for the Ingres2006 users as well as a normal database. Within the distributed database create registrations to the tables in the old database and the new database. There are restrictions on what sort of queries you can run in STAR...which I consider to be the second worst part of Ingres, but otherwise STAR does work very well. I have lots of databases like this and they just don't give me a problem.

Martin Bowes

________________________________

From: info-ingres-bounces (AT) kettleriver...ting (DOT) com on behalf of Colin Hay
Sent: Thu 05/02/2009 12:34
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] Replicator



Our client has an Ingres 2.6 database and an OpenROAD 4.1 application

Rather than do a complete upgrade for all users, they want to create
an Ingres 2006 (or Ingres 9.2) database and run the OpenROAD 2006
version of the same application on that for just a subset of users for
now

However they DO want to keep some tables in both these databases in
sync

I assume Replicator is the product for this - is it easy to use, does
it work properly, what are peoples opinions, or is there a better tool/
method out there ?

Colin Hay
_______________________________________________
Info-Ingres mailing list
Info-Ingres (AT) kettleriverconsulting (DOT) com
http://www.kettleriverconsulting.com...fo/info-ingres

On Feb 5, 2009, at 7:34 AM, Colin Hay wrote:

No, it's not particularly easy to use. It's a fussy and delicate
bolt-on. Given its history, it's actually better than it has any
right to be, but that doesn't make it any more usable.

If your client is doing this for risk mitigation, then I have to
suggest that any real-time replication scheme is going to end up
being harder and riskier than just upgrading everyone. If they
insist, the suggestions of HVR or Star are reasonable.

If they don't have a requirement for real-time updating, i.e. if one
side can be out of date by a few minutes, it might be worth
investigating
the new incremental journaling feature -- I think it's delivered with
9.2, isn't it? Journal out of one database and rollforward into the
other. Of course that only works if updates only flow in one
direction. If you have bidirectional updating, you're back to
a replicator, or Star, or don't-do-that. (The latter is my
preferred option.)

Karl