Replication without deletes

greenspun.com : LUSENET : DBAzine : One Thread

Hi,

I wondered if it is possible to setup replication from an OLTP system to a datawarehouse which replicates all the updates, inserts etc but the deletes in the OLTP system MUST NOT be replicated to the datawarehouse. So the datawarehouse grows and grows (is ok). Is this possible, are there other ways to manage this or is a tool available which can do this?

Who can help me?

Regards, Paul

-- Paul (p.van.rixel@datagis.nl), July 25, 2002


Moderation questions? read the FAQ