Transactional replication

  • Hi,

    I would like to know if subscriber database can skip delete statement from publisher in Transactional replication. I will need to purge data in publisher but not in subscriber database. Subscriber database will keep everything.

    Any thoughts?

    Thanks.

  • Not that I know of - aside from syncing, dropping the subscription, deleting the rows, then recreating the subscription with "replication support only" (no snapshot or anything).

    Otherwise you could put an instead of update trigger on the subscriber to ignore where only the deleted table is filled out, but truncate would then start failing (if it ever was encountered), and it would still fail in merge scenarios. But if it was just straight deletes it might work...

  • Thank you for a quick response. I will continue research on that.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply