MergeSubscription Konstruktor

Referensi

Definisi

Ruang nama:: Microsoft.SqlServer.Replication

Rakitan:: Microsoft.SqlServer.Rmo.dll

Penting

Beberapa informasi terkait produk prarilis yang dapat diubah secara signifikan sebelum dirilis. Microsoft tidak memberikan jaminan, tersirat maupun tersurat, sehubungan dengan informasi yang diberikan di sini.

Membuat instans MergeSubscription baru kelas .

Overload

MergeSubscription()	Membuat instans MergeSubscription baru kelas .
MergeSubscription(String, String, String, String, ServerConnection)	Membuat instans MergeSubscription baru kelas dengan koneksi yang ditentukan ke Publisher dan properti yang secara unik menentukan langganan.

Keterangan

Teks yang diperbarui:17 Juli 2006

Tabel berikut ini memperlihatkan nilai properti default untuk instans MergeSubscriptionbaru . Properti apa pun yang tidak secara eksplisit dijumlahkan dalam tabel ini diinisialisasi ke null nilai.

Properti	Nilai default
AgentOffload	`false`
AgentSchedule	Nilai 99991231 untuk ActiveEndDate Nilai 235959 untuk ActiveEndTime Nilai 0 untuk ActiveStartDate Nilai 0 untuk ActiveStartTime Nilai 1 untuk FrequencyInterval Nilai 0 untuk FrequencyRecurrenceFactor Nilai `First` untuk FrequencyRelativeInterval Nilai `Hour` untuk FrequencySubDay Nilai 1 untuk FrequencySubDayInterval Nilai `Daily` untuk FrequencyType
CachePropertyChanges	`false`
CreateSyncAgentByDefault	`true`
EnabledForSynchronizationManager	`false`
IsExistingObject	`false`
Priority	0
PublisherSecurity	Nilai `true` untuk WindowsAuthentication
Status	Nilai `Inactive` untuk SubscriptionState
SubscriberSecurity	Nilai `true` untuk WindowsAuthentication
SubscriberType	Nilai `Local` untuk MergeSubscriberType
SubscriptionType	Nilai `Push` untuk SubscriptionOption
SynchronizationAgent	Instans MergeSynchronizationAgent dari publikasi yang terkait dengan langganan yang Anda buat.
SyncType	Nilai `Automatic` untuk SubscriptionSyncType
UseInteractiveResolver	`false`

MergeSubscription()

Membuat instans MergeSubscription baru kelas .

public:
 MergeSubscription();

public MergeSubscription ();

Public Sub New ()

Contoh

// 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(publisherName);

// 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(publisherName)

' 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

Keterangan

Konstruktor default menginisialisasi bidang apa pun ke nilai defaultnya.

Lihat juga

Cara: Membuat Langganan Push (Pemrograman RMO)

Berlaku untuk

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

Membuat instans MergeSubscription baru kelas dengan koneksi yang ditentukan ke Publisher dan properti yang secara unik menentukan langganan.

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

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

Public Sub New (publicationName As String, databaseName As String, subscriberName As String, subscriptionDBName As String, connectionContext As ServerConnection)

Parameter

publicationName: String

String Nilai yang menentukan nama publikasi gabungan.

databaseName: String

Nilai String yang menentukan nama database yang berisi publikasi.

subscriberName: String

String Nilai yang menentukan nama Pelanggan yang berlangganan publikasi.

subscriptionDBName: String

Nilai String yang menentukan nama database langganan.

connectionContext: ServerConnection

Nilai ServerConnection objek yang menentukan koneksi ke Publisher.

Berlaku untuk

Bagikan melalui

MergeSubscription Konstruktor

Definisi

Overload

Keterangan

MergeSubscription()

Contoh

Keterangan

Lihat juga

Berlaku untuk

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

Parameter

Berlaku untuk

Sumber Daya Tambahan: