Monday, February 20, 2012

Microsoft SQL Server Publisher Always Wins Conflict Resolver?

Hi experts,
I am using merge repl, in SQL Server 2000.
1) Is there a ready-made "Microsoft SQL Server Publisher Always Wins
Conflict Resolver"? There is one for subscriber, but not one for publisher.
Need that as I just want to "broadcast" the data, and don't want any
subsriber to accidentally corrupt the publisher data.
2) What are "Microsoft SQL Server Download Only Conflict Resolver" and
"Microsoft SQL Server Upload Only Conflict Resolver"?
Many thanks in advance.
The Publisher always wins is the default resolver if you don't do anything.
I'll have a look into (2) and get back to you.
Cheers, Paul Ibison
|||For your resolvers question, "SQL Server Upload Only Conflict Resolver":
Changes uploaded to the Publisher are accepted; changes are not downloaded
to the Subscriber. For downloads it is the inverse.
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