MergePullSubscription Constructors

Definition

Namespace:

Microsoft.SqlServer.Replication

Assembly:

Microsoft.SqlServer.Rmo.dll

Creates a new instance of the MergePullSubscription class.

Overloads

MergePullSubscription()	Creates a new instance of the MergePullSubscription class.
MergePullSubscription(String, String, String, String, ServerConnection)	Initializes a new instance of the MergePullSubscription class with the specified database, Publisher, publication, and Subscriber connection.
MergePullSubscription(String, String, String, String, ServerConnection, Boolean)	Creates a new instance of the MergePullSubscription class with the specified database, Publisher, publication, Subscriber connection, and whether the agent job is created.

Remarks

Updated text: 17 July 2006

The following table shows the default property values for a new instance of MergePullSubscription. Any properties that are not explicitly enumerated in this table are initialized to a null value.

Property	Default value
AgentOffload	false
AgentSchedule	A value of 99991231 for ActiveEndDate A value of 235959 for ActiveEndTime A value of the subscription creation date for ActiveStartDate A value of 0 for ActiveStartTime A value of 1 for FrequencyInterval A value of 0 for FrequencyRecurrenceFactor A value of First for FrequencyRelativeInterval A value of Hour for FrequencySubDay A value of 1 for FrequencySubDayInterval A value of Daily for FrequencyType
CachePropertyChanges	false
CreateSyncAgentByDefault	false
DistributorSecurity	A value of true for WindowsAuthentication
EnabledForSynchronizationManager	false
InternetSecurityMode	A value of true for WindowsAuthentication
InternetTimeout	300
IsExistingObject	false
Priority	0
<xref:Microsoft.SqlServer.Replication.MergePullSubscription.PublisherSecurity%2A>	A value of true for WindowsAuthentication
SubscriberSecurity	A value of true for WindowsAuthentication
SubscriberType	A value of Local for MergeSubscriberType
SubscriptionType	A value of Push for SubscriptionOption
SynchronizationAgent	An instance of MergeSynchronizationAgent from the publication that is associated with the subscription you create.
<xref:Microsoft.SqlServer.Replication.PullSubscription.SyncType%2A>	A value of Automatic for <xref:Microsoft.SqlServer.Replication.PullSubscriptionSyncType>
Type	A value of Merge for PublicationType
UseFtp	false
UseInteractiveResolver	false
UseWebSynchronization	false

MergePullSubscription()

Creates a new instance of the MergePullSubscription class.

public:
 MergePullSubscription();

public MergePullSubscription ();

Public Sub New ()

Remarks

The default constructor initializes any fields to their default values.

MergePullSubscription(String, String, String, String, ServerConnection)

Initializes a new instance of the MergePullSubscription class with the specified database, Publisher, publication, and Subscriber connection.

public:
 MergePullSubscription(System::String ^ subscriptionDBName, System::String ^ publisherName, System::String ^ publicationDBName, System::String ^ publicationName, Microsoft::SqlServer::Management::Common::ServerConnection ^ subscriberConnectionContext);

public MergePullSubscription (string subscriptionDBName, string publisherName, string publicationDBName, string publicationName, Microsoft.SqlServer.Management.Common.ServerConnection subscriberConnectionContext);

new Microsoft.SqlServer.Replication.MergePullSubscription : string * string * string * string * Microsoft.SqlServer.Management.Common.ServerConnection -> Microsoft.SqlServer.Replication.MergePullSubscription

Public Sub New (subscriptionDBName As String, publisherName As String, publicationDBName As String, publicationName As String, subscriberConnectionContext As ServerConnection)

Parameters

subscriptionDBName

String

The subscription database.

publisherName

String

The name of the Publisher.

publicationDBName

String

The name of the publication database.

publicationName

String

The name of the publication.

subscriberConnectionContext

ServerConnection

The connection context required to establish a connection to the instance of MicrosoftSQL Server that is the Subscriber.

MergePullSubscription(String, String, String, String, ServerConnection, Boolean)

Creates a new instance of the MergePullSubscription class with the specified database, Publisher, publication, Subscriber connection, and whether the agent job is created.

public:
 MergePullSubscription(System::String ^ subscriptionDBName, System::String ^ publisherName, System::String ^ publicationDBName, System::String ^ publicationName, Microsoft::SqlServer::Management::Common::ServerConnection ^ subscriberConnectionContext, bool createMergeAgentByDefault);

public MergePullSubscription (string subscriptionDBName, string publisherName, string publicationDBName, string publicationName, Microsoft.SqlServer.Management.Common.ServerConnection subscriberConnectionContext, bool createMergeAgentByDefault);

new Microsoft.SqlServer.Replication.MergePullSubscription : string * string * string * string * Microsoft.SqlServer.Management.Common.ServerConnection * bool -> Microsoft.SqlServer.Replication.MergePullSubscription

Public Sub New (subscriptionDBName As String, publisherName As String, publicationDBName As String, publicationName As String, subscriberConnectionContext As ServerConnection, createMergeAgentByDefault As Boolean)

Parameters

subscriptionDBName

String

A String value that specifies the name of the subscription database.

publisherName

String

A String value that specifies the name of the Publisher.

publicationDBName

String

A String value that specifies the name of the publication database.

publicationName

String

A String value that specifies the name of the publication.

subscriberConnectionContext

ServerConnection

A ServerConnection object that specifies the connection context required to establish a connection to the instance of MicrosoftSQL Server that is the Subscriber.

createMergeAgentByDefault

Boolean

Specifies whether or not the agent job for the subscription is created when the subscription is created.

Remarks

Specify a value of true for createMergeAgentByDefault when you need to schedule synchronization, or when you need to synchronize the subscription from SQL Server Management Studio. Specify a value of false if the Replication Agent will always be started programmatically without using SQL Server Agent.

When you specify a value of false for createMergeAgentByDefault, the MergeSynchronizationAgent or TransSynchronizationAgent objects obtained from the SynchronizationAgent property will not have enough information to successfully synchronize the subscription. For more information, see How to: Synchronize a Pull Subscription (RMO Programming).