Undoing Merge replication

Question

Undoing Merge replication

P G-228798

Valued Member

Points: 60
More actions
September 23, 2005 at 5:23 am

#90002

Hi,
The powers that be have decided that we have been replicating too much data to one of our client companies. Is there a way that I can remove this data from their database?
I am now considering filtering the replicated data by row depending on the client company's country of origin. If I do this is it possible to make the filter general enough that I can use one publication for several clients?
TIA,
Phil

Viewing 4 posts - 1 through 4 (of 4 total)

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

homebrew01 SSC Guru Points: 55553 More actions · Answer 1

You can add a filter, which will mark the subscription for reinitialization, then a new snapshot will re-populate the tables with the filter criteria.

I'm not sure what you mean by " ...is it possible to make the filter general enough that I can use one publication for several clients?" Could you be a bit more specific ?

The filter can be as general or specific as you want. It's basically a WHERE clause that you add to the select that is done against the publisher.

P G-228798 Valued Member Points: 60 More actions · Answer 2

Hi Homebrew,

Thanks for taking the time to help me out.

So a filter will limit the data replicated to the subscriber, and also remove data from the subscriber that doesn't match the filter criteria?

To be more specific, we have data pertaining to, and clients spread over, several countries. We would like to filter the data replicated so that each client only gets data relevant to their locale. I mean the client only gets data associated with their country of origin.

So from what you are saying I could add a WHERE clause that filters on the subscriber replicating?

homebrew01 SSC Guru Points: 55553 More actions · Answer 3

You could set up a publication for each location.

For England, you create a publication with your account information, let's say your account table is ACCOUNTS and the field is COUNTRY. In the row filter area, you simply add COUNTRY = 'ENGLAND'. And then set up another publication for France with COUNTRY = 'FRANCE'. Each country will have it's own subscription that pulls from it's own publication. I don't think replication will delete rows for FRANCE that are already on the ENGLAND database. You will either have to delete them manually, or reinitialize the subscription to rebuild the table from scratch after creating the filters.

You could set up a practice database on each server and create a few practice publications with some sample data to try it out first.