SEO

#1 (**permalink**) 02-29-2008, 07:47 AM

Hello all. We are just getting started with replication and I'm
wondering if there is a way to not have deletes replicated. I know I
could manually remove the delete trigger from every table but I'm
intrested in have this a bit more automatic (like when its creating the
subscription).

Thanks

Stephen

#2 (**permalink**) 02-29-2008, 07:48 AM

If you don't replicate deletes, then you're not really replicating the
data any more - what happens if a row on the publisher is deleted, then
a new row is inserted with the same primary key? If you don't replicate
deletes, then the replicated insert will fail on the subscriber due to
a primary key violation.

Having said that, it's not clear why you want to want to do this -
perhaps if you can give some more details of what you need to achieve
someone will have a suggestion.

Simon

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Stop replication of deletes