Jaa


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 _
)
public void ResynchronizeSubscription (
    string subscriber,
    string subscriptionDB,
    ResynchronizeType synchronizeType,
    string dateTime
)
public:
void ResynchronizeSubscription (
    String^ subscriber, 
    String^ subscriptionDB, 
    ResynchronizeType synchronizeType, 
    String^ dateTime
)
public void ResynchronizeSubscription (
    String subscriber, 
    String subscriptionDB, 
    ResynchronizeType synchronizeType, 
    String dateTime
)
public function ResynchronizeSubscription (
    subscriber : String, 
    subscriptionDB : String, 
    synchronizeType : ResynchronizeType, 
    dateTime : String
)

Parameters

  • subscriber
    A String value that specifies the Subscriber.
  • subscriptionDB
    A String value that specifies the subscription database.
  • synchronizeType
    A ResynchronizeType value that specifies the resynchronization type.
  • dateTime
    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.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

MergePublication Class
MergePublication Members
Microsoft.SqlServer.Replication Namespace