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

public SubscriberUploadOptions SubscriberUploadOption { get; set; }

public:
property SubscriberUploadOptions SubscriberUploadOption {
    SubscriberUploadOptions get ();
    void set (SubscriberUploadOptions value);
}

/** @property */
public SubscriberUploadOptions get_SubscriberUploadOption ()

/** @property */
public void set_SubscriberUploadOption (SubscriberUploadOptions value)

public function get SubscriberUploadOption () : SubscriberUploadOptions

public function set SubscriberUploadOption (value : SubscriberUploadOptions)

Property Value

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).

The SubscriberUploadOption property is available with Microsoft SQL Server 2005 only.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

MergeArticle Class
MergeArticle Members
Microsoft.SqlServer.Replication Namespace

Other Resources

Optimizing Merge Replication Performance with Download-Only Articles