How to synchronize tables between several (at least two) database ?
I have DB1, DB2, DB3.... which contains table A, table B ...
As long as I Modify table A in any of the DB, then the table A in all the rest DB should be syncronized. same for table B, (but not whole database)...
There is no master and slave database, all DB (could be in different server)should be running.
Is there any mechenism for informix to do synchronize only on table level?
Or i am obliged to use trigger statetments on each table on update, delete, and insert ,then launch the trigger action in other DBs to do the same update, delete, insert? Is there simple solution?