MergeSubscription MergeSubscription MergeSubscription Constructors

정의

오버로드

MergeSubscription() MergeSubscription() MergeSubscription()

새 인스턴스를 만듭니다는 MergeSubscription 클래스입니다. Creates a new instance of the MergeSubscription class.

MergeSubscription(String, String, String, String, ServerConnection) MergeSubscription(String, String, String, String, ServerConnection) MergeSubscription(String, String, String, String, ServerConnection)

게시자에 대한 지정된 연결 및 구독을 고유하게 정의하는 속성을 사용하여 MergeSubscription 클래스의 새 인스턴스를 만듭니다. Creates a new instance of the MergeSubscription class with the specified connection to the Publisher and the properties that uniquely define the subscription.

설명

Updated text: 17 July 2006 17 July 2006

다음 표에서 기본값의 새 인스턴스에 대 한 속성 값이 표시 MergeSubscription합니다.The following table shows the default property values for a new instance of MergeSubscription. 이 테이블에 명시적으로 열거 하지 하는 모든 속성으로 초기화 됩니다는 null 값입니다.Any properties that are not explicitly enumerated in this table are initialized to a null value.

속성Property 기본값Default value
AgentOffload false
AgentSchedule 에 대 한 99991231 값 ActiveEndDateA value of 99991231 for ActiveEndDate

에 대 한 235959 값 ActiveEndTimeA value of 235959 for ActiveEndTime

값이 0에 대 한 ActiveStartDateA value of 0 for ActiveStartDate

값이 0에 대 한 ActiveStartTimeA value of 0 for ActiveStartTime

값이 1 FrequencyIntervalA value of 1 for FrequencyInterval

값이 0에 대 한 FrequencyRecurrenceFactorA value of 0 for FrequencyRecurrenceFactor

값이 First 에 대 한 FrequencyRelativeIntervalA value of First for FrequencyRelativeInterval

값이 Hour 에 대 한 FrequencySubDayA value of Hour for FrequencySubDay

값이 1 FrequencySubDayIntervalA value of 1 for FrequencySubDayInterval

값이 Daily 에 대 한 FrequencyTypeA value of Daily for FrequencyType
CachePropertyChanges false
CreateSyncAgentByDefault true
EnabledForSynchronizationManager false
IsExistingObject false
Priority 00
PublisherSecurity 값이 true 에 대 한 WindowsAuthenticationA value of true for WindowsAuthentication
Status 값이 Inactive 에 대 한 SubscriptionStateA value of Inactive for SubscriptionState
SubscriberSecurity 값이 true 에 대 한 WindowsAuthenticationA value of true for WindowsAuthentication
SubscriberType 값이 Local 에 대 한 MergeSubscriberTypeA value of Local for MergeSubscriberType
SubscriptionType 값이 Push 에 대 한 SubscriptionOptionA value of Push for SubscriptionOption
SynchronizationAgent 인스턴스 MergeSynchronizationAgent 의 연결 된 사용자가 만드는 게시 합니다.An instance of MergeSynchronizationAgent from the publication that is associated with the subscription you create.
SyncType 값이 Automatic 에 대 한 SubscriptionSyncTypeA value of Automatic for SubscriptionSyncType
UseInteractiveResolver false

MergeSubscription() MergeSubscription() MergeSubscription()

새 인스턴스를 만듭니다는 MergeSubscription 클래스입니다. Creates a new instance of the MergeSubscription class.

public:
 MergeSubscription();
public MergeSubscription ();
Public Sub New ()

예제

// Define the Publisher, publication, and databases.
string publicationName = "AdvWorksSalesOrdersMerge";
string publisherName = publisherInstance;
string subscriberName = subscriberInstance;
string subscriptionDbName = "AdventureWorks2012Replica";
string publicationDbName = "AdventureWorks2012";
string hostname = @"adventure-works\garrett1";

//Create a connection to the Publisher.
ServerConnection conn = new ServerConnection(subscriberName);

// Create the objects that we need.
MergePublication publication;
MergeSubscription subscription;

try
{
	// Connect to the Publisher.
	conn.Connect();

	// Ensure that the publication exists and that 
	// it supports push subscriptions.
	publication = new MergePublication();
	publication.Name = publicationName;
	publication.DatabaseName = publicationDbName;
	publication.ConnectionContext = conn;

	if (publication.IsExistingObject)
	{
		if ((publication.Attributes & PublicationAttributes.AllowPush) == 0)
		{
			publication.Attributes |= PublicationAttributes.AllowPush;
		}

		// Define the push subscription.
		subscription = new MergeSubscription();
		subscription.ConnectionContext = conn;
		subscription.SubscriberName = subscriberName;
		subscription.PublicationName = publicationName;
		subscription.DatabaseName = publicationDbName;
		subscription.SubscriptionDBName = subscriptionDbName;
		subscription.HostName = hostname;

		// Set a schedule to synchronize the subscription every 2 hours
		// during weekdays from 6am to 10pm.
		subscription.AgentSchedule.FrequencyType = ScheduleFrequencyType.Weekly;
		subscription.AgentSchedule.FrequencyInterval = Convert.ToInt32(0x003E);
		subscription.AgentSchedule.FrequencyRecurrenceFactor = 1;
		subscription.AgentSchedule.FrequencySubDay = ScheduleFrequencySubDay.Hour;
		subscription.AgentSchedule.FrequencySubDayInterval = 2;
		subscription.AgentSchedule.ActiveStartDate = 20051108;
		subscription.AgentSchedule.ActiveEndDate = 20071231;
		subscription.AgentSchedule.ActiveStartTime = 060000;
		subscription.AgentSchedule.ActiveEndTime = 100000;

		// Specify the Windows login credentials for the Merge Agent job.
		subscription.SynchronizationAgentProcessSecurity.Login = winLogin;
		subscription.SynchronizationAgentProcessSecurity.Password = winPassword;

		// Create the push subscription.
		subscription.Create();
	}
	else
	{
		// Do something here if the publication does not exist.
		throw new ApplicationException(String.Format(
			"The publication '{0}' does not exist on {1}.",
			publicationName, publisherName));
	}
}
catch (Exception ex)
{
	// Implement the appropriate error handling here.
	throw new ApplicationException(String.Format(
		"The subscription to {0} could not be created.", publicationName), ex);
}
finally
{
	conn.Disconnect();
}
' Define the Publisher, publication, and databases.
Dim publicationName As String = "AdvWorksSalesOrdersMerge"
Dim publisherName As String = publisherInstance
Dim subscriberName As String = subscriberInstance
Dim subscriptionDbName As String = "AdventureWorks2012Replica"
Dim publicationDbName As String = "AdventureWorks2012"
Dim hostname As String = "adventure-works\garrett1"

'Create a connection to the Publisher.
Dim conn As ServerConnection = New ServerConnection(subscriberName)

' Create the objects that we need.
Dim publication As MergePublication
Dim subscription As MergeSubscription

Try
    ' Connect to the Publisher.
    conn.Connect()

    ' Ensure that the publication exists and that 
    ' it supports push subscriptions.
    publication = New MergePublication()
    publication.Name = publicationName
    publication.DatabaseName = publicationDbName
    publication.ConnectionContext = conn

    If publication.IsExistingObject Then
        If (publication.Attributes And PublicationAttributes.AllowPush) = 0 Then
            publication.Attributes = publication.Attributes _
            Or PublicationAttributes.AllowPush
        End If

        ' Define the push subscription.
        subscription = New MergeSubscription()
        subscription.ConnectionContext = conn
        subscription.SubscriberName = subscriberName
        subscription.PublicationName = publicationName
        subscription.DatabaseName = publicationDbName
        subscription.SubscriptionDBName = subscriptionDbName
        subscription.HostName = hostname

        ' Set a schedule to synchronize the subscription every 2 hours
        ' during weekdays from 6am to 10pm.
        subscription.AgentSchedule.FrequencyType = ScheduleFrequencyType.Weekly
        subscription.AgentSchedule.FrequencyInterval = Convert.ToInt32("0x003E", 16)
        subscription.AgentSchedule.FrequencyRecurrenceFactor = 1
        subscription.AgentSchedule.FrequencySubDay = ScheduleFrequencySubDay.Hour
        subscription.AgentSchedule.FrequencySubDayInterval = 2
        subscription.AgentSchedule.ActiveStartDate = 20051108
        subscription.AgentSchedule.ActiveEndDate = 20071231
        subscription.AgentSchedule.ActiveStartTime = 60000
        subscription.AgentSchedule.ActiveEndTime = 100000

        ' Specify the Windows login credentials for the Merge Agent job.
        subscription.SynchronizationAgentProcessSecurity.Login = winLogin
        subscription.SynchronizationAgentProcessSecurity.Password = winPassword

        ' Create the push subscription.
        subscription.Create()
    Else

        ' Do something here if the publication does not exist.
        Throw New ApplicationException(String.Format( _
         "The publication '{0}' does not exist on {1}.", _
         publicationName, publisherName))
    End If
Catch ex As Exception
    ' Implement the appropriate error handling here.
    Throw New ApplicationException(String.Format( _
    "The subscription to {0} could not be created.", publicationName), ex)
Finally
    conn.Disconnect()
End Try

설명

기본 생성자는 모든 필드를 기본값으로 초기화합니다.The default constructor initializes any fields to their default values.

추가 정보

MergeSubscription(String, String, String, String, ServerConnection) MergeSubscription(String, String, String, String, ServerConnection) MergeSubscription(String, String, String, String, ServerConnection)

게시자에 대한 지정된 연결 및 구독을 고유하게 정의하는 속성을 사용하여 MergeSubscription 클래스의 새 인스턴스를 만듭니다. Creates a new instance of the MergeSubscription class with the specified connection to the Publisher and the properties that uniquely define the subscription.

public:
 MergeSubscription(System::String ^ publicationName, System::String ^ databaseName, System::String ^ subscriberName, System::String ^ subscriptionDBName, Microsoft::SqlServer::Management::Common::ServerConnection ^ connectionContext);
public MergeSubscription (string publicationName, string databaseName, string subscriberName, string subscriptionDBName, Microsoft.SqlServer.Management.Common.ServerConnection connectionContext);
Public Sub New (publicationName As String, databaseName As String, subscriberName As String, subscriptionDBName As String, connectionContext As ServerConnection)
매개 변수
publicationName
String String String

병합 게시의 이름을 지정하는 String 값입니다. A String value that specifies the name of the merge publication.

databaseName
String String String

게시가 포함된 데이터베이스의 이름을 지정하는 String 값입니다. A String value that specifies the name of the database that contains the publication.

subscriberName
String String String

게시를 구독하는 구독자의 이름을 지정하는 String 값입니다. A String value that specifies the name of the Subscriber that subscribes to the publication.

subscriptionDBName
String String String

구독 데이터베이스의 이름을 지정하는 String 값입니다. A String value that specifies the name of the subscription database.

connectionContext
Microsoft.SqlServer.Management.Common.ServerConnection Microsoft.SqlServer.Management.Common.ServerConnection Microsoft.SqlServer.Management.Common.ServerConnection

게시자에 대한 연결을 지정하는 Microsoft.SqlServer.Management.Common.ServerConnection 개체 값입니다. A Microsoft.SqlServer.Management.Common.ServerConnection object value that specifies the connection to the Publisher.

적용 대상