Re: Replication for Archiving ? Is it possible ?

Posted in 1997

David Williams — Sat, 17 May 1997 01:05:03 +0100 — source: Informix-list mailing list archive (1991-1998)

In article <337c4ef6.10528509@ct-news.iafrica.com>, Henry <henryk@mda.co.za> writes >Many log-based data replication systems allow to select, on per-table >basis, transaction types replicated to other databases. This can be >used as a vehicle to implement an archiving facility where all inserts >and updates are replicated, but the deletes are not. In that way a >small 'transaction' database can be maintained where transactions >older than x days can be deleted - allowing fast user access, with >continuously growing archive database where all transaction records >are stored. > >Microsoft SQL directly supports such facility and it can be done in >Oracle by customizing its replication triggers. Is there anything >similar I could use on Informix platform to achieve similar result ? > >Please help anyone , > >Henryk Nowicki >Cape Town > > Look into Informix CDR (Continuous Data Replication) available with Online 7.2. -- David Williams