Tuesday, March 20, 2012

Problems with merge replication and pull subscription

Hi, i have configured a merge replication with pull subscription. The
articles of the publication has filters defined. The filters are like
this:
where divis in (1, 2, 3, 4, 5)
Last week on the subscriber a user insert information where divis = 6,
so the replicatin sent the data to the publication but it was deleted
in the subscriber.
I have the doubt, Why the replication sent the information to the
publisher, if it wasn't part of the filters?
Why does the replication delete the information in the subscriber?
At this moment I already change the article filters', and this is the
new filter:
where divis in (1, 2, 3, 4, 5, 6)
And everything is working find.
Thanks a lot for your help.
*** Sent via Developersdex http://www.codecomments.com ***
Maria,
this is normal. There is a view created which 'defines' your filter and this
view however only exists at the publisher. So, the check is done after the
data is uploaded and a delete sent to the client to remove the record. The
filter applies to the publication when synchronizing so the data isn't
removed at this stage. I must admit I can think of more intuitive designs,
but this design does have occasional advantages when you need to amalgamate
data.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment