Share via


MergeArticle.SubscriberUploadOption Property

Gets or sets the behavior of updates made at a Subscriber with a client subscription.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public Property SubscriberUploadOption As SubscriberUploadOptions 
    Get 
    Set
'Usage
Dim instance As MergeArticle 
Dim value As SubscriberUploadOptions 

value = instance.SubscriberUploadOption

instance.SubscriberUploadOption = value
public SubscriberUploadOptions SubscriberUploadOption { get; set; }
public:
property SubscriberUploadOptions SubscriberUploadOption {
    SubscriberUploadOptions get ();
    void set (SubscriberUploadOptions value);
}
member SubscriberUploadOption : SubscriberUploadOptions with get, set
function get SubscriberUploadOption () : SubscriberUploadOptions 
function set SubscriberUploadOption (value : SubscriberUploadOptions)

Property Value

Type: Microsoft.SqlServer.Replication.SubscriberUploadOptions
A SubscriberUploadOptions value.

Remarks

The SubscriberUploadOption property can be retrieved by members of the sysadmin fixed server role at the Publisher and at the Subscriber (for republishing Subscribers). It can also be retrieved by members of the db_owner fixed database role on the publication database, by members of the replmonitor fixed database role at the Distributor, and by users who are members of the publication access list (PAL).

The SubscriberUploadOption property can be set by members of the sysadmin fixed server role at the Publisher. It can also be set by members of the db_owner fixed database role on the publication database.

Retrieving SubscriberUploadOption is equivalent to executing sp_helpmergearticle (Transact-SQL).

Setting SubscriberUploadOption is equivalent to executing sp_addmergearticle (Transact-SQL) or sp_changemergearticle (Transact-SQL).

See Also

Reference

MergeArticle Class

Microsoft.SqlServer.Replication Namespace

Other Resources

Optimize Merge Replication Performance with Download-Only Articles