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
- subscriber
Type: System.String
The Subscriber.
- subscriptionDB
Type: System.String
The subscription database.
- synchronizeType
Type: Microsoft.SqlServer.Replication.ResynchronizeType
The resynchronization type.
- dateTime
Type: System.String
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.