Merge Replication Filter does not work at Subscriber
- From: "Vikas Kohli" <VikasKohli@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 6 Jun 2005 04:21:02 -0700
I am setting up a SQL Server Database Filter based Merge Replication between
Publisher (on Server Global) & Subscriber (on Server Site) using
EXCHANGE_TYPE '1' (Data only needs to be merged from Subscriber(Site) to
Publisher(Global) - Upload). You can consider this as a Central Subscriber
model with multiple Publications based on Filter "Siteid" push Data to
Central Subscriber Global. I have created all the Publications in the Central
Publisher Database Global (Normally central subscriber model will have
Publications on each site but I did wanted to do that due to Maintenance &
security issues )
Also I have set up conflict resolver "SQL Server Subscriber always wins the
conflict" since I want my Subscriber changes to override changes done at
Publisher.
However, I am facing this issue:
Even if I add a row at subscriber Site that is not part of Filter (it goes
into the Publisher Global). I do not want the rows other than filter clause
to replicate to Central Hub.
Any assistance is highly appreciated!
Database : SQL Server 2000 SP3a
OS: Win2003 (No Service Pack)
.
- Follow-Ups:
- Re: Merge Replication Filter does not work at Subscriber
- From: Paul Ibison
- Re: Merge Replication Filter does not work at Subscriber
- Prev by Date: Re: Merge-Agent error
- Next by Date: RE: sp_addsubscription problem
- Previous by thread: Foreign Keys and Replication
- Next by thread: Re: Merge Replication Filter does not work at Subscriber
- Index(es):
Relevant Pages
|