Expert: Jean-Pierre Zuate - 8/29/2007

Question
I have a procedure that fires a rule if DatabaseA.TableA has row inserted based on certain criteria. I need to include with the procedure an insert to DatabaseB.TableA (same table name, different database - different server). I have verified the two communicate but can't get the insert to DatabaseB to work. I'm wondering if this is even possible at this point. If so, any suggestions??

Answer
Hello Jenna,

What you need is to replicate your INSERT (UPDATE or DELETE) from DatabaseA to DatabaseB. All depend if you want the "replication" in the same transaction or not.

In the same transaction, then you must use Ingres Federated Database (old name: Ingres Start). In short terms, you would then able to link a table from a database to an other (from dbA to dbB) and the INSERT in the dbA will be done automaticaly in the dbB.

In 2 transactions, the use Ingres/Replicator. You would then be able to replicate all data movements from a database to an other (if tables have same structure, name and so on).

The more simple should be, I think, to use Replicator (but you must ask you what happen if a row of this table is updated in the dbB, to you replicate data into dbA or not, etc).

In both cases, it is some new concepts to learn and to work with (debugging Star or Replicator problems can be hard - but not undoable).

Hope this help you.

Kind regards ...