This topic has not yet been rated - Rate this topic

TransSynchronizationAgent.SubscriptionType Property

SQL Server 2008

Gets or sets whether the subscription is a push or pull subscription.

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

Syntax

C++

JScript

public virtual SubscriptionOption SubscriptionType { get; set; }

Property Value

Type: Microsoft.SqlServer.Replication.SubscriptionOption
A SubscriptionOption value that indicates the subscription type.

Implements

ITransSynchronizationAgent.SubscriptionType

Remarks

The type of subscription you choose depends on where the agent runs. With a push subscription, the Distribution Agent runs at the Distributor; whereas, with a pull subscription, agent runs at the Subscriber. Anonymous subscriptions are required if you want to create a subscription without registering the subscription at the Publisher. This is necessary for cases in which you cannot establish a SQL Server connection to the Publisher during subscription configuration.

Reference

TransSynchronizationAgent Class

TransSynchronizationAgent Members

Microsoft.SqlServer.Replication Namespace

Other Resources

Subscribing to Publications

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD