Re: Replication of limited data

jfanders@my-dejanews.com wrote: > > I have a need to replicate limited data changes that occur in a database to a > second database. The two databases reside on the same machine. For example > when 100 of the 500 tables in database "A" change (through an update, insert, > or delete) I would like to replicate those changes in database "B", but I do > not want to replicate changes made to the other 400 tables. Also, when > changes are made on database "B" I do NOT want the changes replicated back to > database "A". Essentially database "B" is a subset of database "A". Two > different groups of users will access the two databases. I believe I can do > this with triggers, but am wondering if there is an easier way. From what > I've read on Informix Data Replication, it seems to be an all or nothing > thing. > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- > http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Check out IER (Informix Enterprise Replication). This will do exactly what you want with minimal effort. You will need primary keys on the 100 tables (these are used for comparison for replication). IER will support uni-directional replication of specific tables. Plus it's pretty quick! -Joseph -- Joseph Kormann jkormann@mcs.mds.lmco.com Ph:732/450-7126 Fx:732/450-7153 Team MCS - Go Team!