Re: Enterprise Replication

I haven't used ER, but could you replicate to an 'intermediate' table, with insert and update triggers, and have those triggers insert/update your 'real' table? Then the deletes would affect the intermediate table, but since you do not have a trigger on the deletes, they are not passed on to the 'real' table. Of course, this has the disadvantage of using a different table name for the history. Doug Agnew DBA Charlotte Pipe & Foundry Malcolm McNeill wrote: > Has anyone out there set up Enterprise Replication in such a way > that deletions on the source table are ignored on the target table? > > In our particular scenario we would like to replicate any inserts > or updates to a particular table from the source to the target. > However, we want to keep all of data on the target database for > historical reporting, and therefore don't wish to process deletes > that occur on the source database. > > It looks like this might be accomplished via stored procedures, > however I would welcome any input. > > Malcolm McNeill > Database Administrator > mcneill@anasazi.com