all groups > sql server replication > january 2004 >
You're in the

sql server replication

group:

One way merge replication?


One way merge replication? Brian Newtz
1/21/2004 12:36:05 PM
sql server replication:
Hello

I'm currently trying to implement replication with a "Central Subscriber" approach, where every server is only using MSDE. Hence, I only have Snapshot or Merge replication to choose from. Snapshot replication seems undoable since it sends the whole snapshot every single time, instead of just new/edited/deleted rows. So my only other alternative is Merge replication.

The problem is, I don't want the central subscriber's changes (if any) to be propagated back to the Publishers. Is there any way I can stop the subscriber from doing this

Thanks
Re: One way merge replication? Mary Bray
1/22/2004 6:14:41 PM
Have a look at the Books On Line under "Replication Merge Agent Utility" and
look at the -ExchangeType parameter

[quoted text, click to view]
approach, where every server is only using MSDE. Hence, I only have Snapshot
or Merge replication to choose from. Snapshot replication seems undoable
since it sends the whole snapshot every single time, instead of just
new/edited/deleted rows. So my only other alternative is Merge replication.
[quoted text, click to view]
be propagated back to the Publishers. Is there any way I can stop the
subscriber from doing this?
[quoted text, click to view]

AddThis Social Bookmark Button