Post reply

Transactional replication

  • April 10, 2014 at 3:06 pm

    #284473

    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.

  • April 10, 2014 at 7:40 pm

    #1705092

    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...

  • April 11, 2014 at 7:34 am

    #1705280

    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