MergePullSubscription Constructors
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
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 FrequencyRelativeIntervalA value of Hour for FrequencySubDayA 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.
Applies to
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.MergePullSubscriptionPublic 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.
Applies to
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.MergePullSubscriptionPublic Sub New (subscriptionDBName As String, publisherName As String, publicationDBName As String, publicationName As String, subscriberConnectionContext As ServerConnection, createMergeAgentByDefault As Boolean)Parameters
- 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).