Sdílet prostřednictvím

  • Článek

MergePublication.ResynchronizeSubscription Method

Resynchronizes a merge subscription to a known validation state that you specify.

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

Syntax

'Declaration
Public Sub ResynchronizeSubscription ( _
    subscriber As String, _
    subscriptionDB As String, _
    synchronizeType As ResynchronizeType, _
    dateTime As String _
)
'Usage
Dim instance As MergePublication
Dim subscriber As String
Dim subscriptionDB As String
Dim synchronizeType As ResynchronizeType
Dim dateTime As String

instance.ResynchronizeSubscription(subscriber, _
    subscriptionDB, synchronizeType, _
    dateTime)

public void ResynchronizeSubscription(
    string subscriber,
    string subscriptionDB,
    ResynchronizeType synchronizeType,
    string dateTime
)

public:
void ResynchronizeSubscription(
    String^ subscriber, 
    String^ subscriptionDB, 
    ResynchronizeType synchronizeType, 
    String^ dateTime
)

member ResynchronizeSubscription : 
        subscriber:string * 
        subscriptionDB:string * 
        synchronizeType:ResynchronizeType * 
        dateTime:string -> unit 

public function ResynchronizeSubscription(
    subscriber : String, 
    subscriptionDB : String, 
    synchronizeType : ResynchronizeType, 
    dateTime : String
)

Parameters

  • dateTime
    Type: System.String
    A String value that represents the date and time from which the changes are resynchronized.

Remarks

The ResynchronizeSubscription method allows you to force convergence or synchronize the subscription database to a specific point in time, such as the last time there was a successful validation, or to a specified date. The snapshot is not reapplied when resynchronizing a subscription using this method.

The ReadLastValidationDateTimes method can be used to determine the date and time of the last successful validation of the subscription

Calling ResynchronizeSubscription is equivalent to executing sp_resyncmergesubscription.

The ResynchronizeSubscription method can only be called by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.

The ResynchronizeSubscription method is available only for instances of Microsoft SQL Server 2000 and Microsoft SQL Server 2005.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.