Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Delete Data from Publisher Without Replicating to Subscribers


Delete Data from Publisher Without Replicating to Subscribers

Author
Message
irobertson
irobertson
SSC Veteran
SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)SSC Veteran (247 reputation)

Group: General Forum Members
Points: 247 Visits: 675
Hi all,

I have a requirement to archive a large volume of data from a table (T1) within my published database. However, I want the archived data to remain visible and available on the subscriber databases (of which there are a very large number, each receiving a discrete partition of the published db's data).

There are no updates to T1, only inserts and deletes. The inserts are driven by selection criteria held in other tables that I will not be removing data from. The selection process populates a set of records into the table to be archived. Deletes only occur when a selection is re-run, as the current T1 set is removed and a new set is inserted.

I am thinking of disabling the replication triggers on T1, removing the data, then re-enabling the triggers. Is this a bad idea? My primary concern is what happens if a selection is re-run and delete actions are triggered for records that no longer exist at the publisher. Will this cause issues when the subscriber replicates?

Is there anything else that I should be thinking about here?

Regards, Iain

Edit:

Selections can be run at both subscriber and publisher. Replication is MERGE.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search