Re: Merge Replication Filter does not work at Subscriber

Vikas,
you could use an instead-of trigger for this, and divert these rows to
another table.
Alternatively you could use partitioned tables (like federated database
servers but all on one database).
Another alternative is to edit the merge triggers to not record these rows
in the metadata tables.
Rgds,
Paul Ibison

"Vikas Kohli" <VikasKohli@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ACFC59F9-7CE5-4869-83D3-7CB836E6E273@xxxxxxxxxxxxxxxx
>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)


.

Relevant Pages

  • Re: Viewing lists from a different server
    ... Instead of accessing the WSS database you ... when the site is on a different server. ... large list of items that sub-sites filter according to a custom ... action to display the filtered list on a site on this second server. ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: New to selling on eBay
    ... believe everything is the same database. ... server if one is a mainframe IBM and the other a Sun server. ... I look for U.S. coins on these sites by entering a filter exclusion ... they let me filter Russian coins as to ...
    (rec.collecting.coins)
  • Re: Lock a Form From Multiple Users
    ... system located in multiple areas is to use a Terminal Server. ... either on the Terminal Server or on a separate server, ... database splitter wizard. ... has a filter for loans and one has a filter for deposits. ...
    (microsoft.public.access.forms)
  • Re: Where is the processing done - VS2005 Web development
    ... the selects are run against the database. ... it will take place on the web server inside ... I have a view in my SQL Server 2000 database. ... If I want to filter the data then within the data table I add a table ...
    (microsoft.public.dotnet.framework.aspnet.datagridcontrol)
  • Create SharePoint Portal failed.
    ... One mentioned ensuring that SQL Server uses a case ... 13:55:40 Service database server is 'USDC-JOHRIV'. ... Update dbo.propertylist set DisplayName = N'Last name' ...
    (microsoft.public.sharepoint.portalserver)