Within SQL Server's merge replication, I know how to make publication's article download-only (either with update restrictions on subscriber database or not) – @subscriber_upload_options parameter in sp_addmergearticle, or corresponding choices in the SSMS's GUI.
What I would like to achieve though is the reverse behavior on some articles. So that records that originate on the subscriber's side travel up to the publisher during syncronization, but not the other way around. And that updates made on the publisher are not sync'ed back to the subscriber, while updates made on subscriber do go up to the publisher. I.e. exactly reverse of the download-only articles.
Is this possible to achieve? Either with "standard" configuration options of the replication or with some manual hacks?
Best Answer
You can add a filter like: 0 = 1, and the article becomes upload only