Share via


SQLMerge Object (Replication ActiveX)

The SQL Merge control is implemented as a Microsoft ActiveX in-process component. The SQL Merge control provides an alternate way, in addition to the Merge Agent, to synchronize merge subscriptions. Its primary class, the SQLMerge object, provides the functionality of the Merge Agent and supports synchronization of push, pull, or anonymous subscriptions to a merge publication. The SQLMerge object also includes the options to:

  • Add or drop subscriptions.
  • Specify whether only the upload phase, only the download phase, or both phases are run.
  • Specify an alternate snapshot folder, from which the initial snapshot for a subscription can be applied.
  • Attach a subscription database by specifying only Subscriber-side properties.
  • Validate that a subscription has the expected data.
ms147327.security(en-US,SQL.90).gifSecurity Note:
The SQL Distribution control is designated as "not safe for scripting" and "not safe for initialization."

Properties

AlternateSyncPartners Property (Replication ActiveX)

AltSnapshotFolder Property (Replication ActiveX)

Distributor Property (Replication ActiveX)

DistributorAddress Property (Replication ActiveX)

DistributorLogin Property (Replication ActiveX)

DistributorNetwork Property (Replication ActiveX)

DistributorPassword Property (Replication ActiveX)

DistributorSecurityMode Property (Replication ActiveX)

DynamicSnapshotLocation Property

ErrorRecords Property (Replication ActiveX)

ExchangeType Property (Replication ActiveX)

FileTransferType Property (Replication ActiveX)

FTPAddress Property (Replication ActiveX)

FTPLogin Property (Replication ActiveX)

FTPPassword Property (Replication ActiveX)

FTPPort Property (Replication ActiveX)

HostName Property (Replication ActiveX)

InternetLogin Property (Replication ActiveX)

InternetPassword Property (Replication ActiveX)

InternetProxyLogin Property (Replication ActiveX)

InternetProxyPassword Property (Replication ActiveX)

InternetProxyServer Property (Replication ActiveX)

InternetTimeout Property (Replication ActiveX)

InternetURL Property (Replication ActiveX)

LastUpdatedTime Property (Replication ActiveX)

LoginTimeout Property (Replication ActiveX)

MetadataRetentionCleanup Property (Replication ActiveX)

Output Property (Replication ActiveX)

OutputVerboseLevel Property (Replication ActiveX)

ProfileName Property (Replication ActiveX)

Publication Property (Replication ActiveX)

Publisher Property (Replication ActiveX)

PublisherAddress Property (Replication ActiveX)

PublisherChanges Property (Replication ActiveX)

PublisherConflicts Property (Replication ActiveX)

PublisherDatabase Property (Replication ActiveX)

PublisherLogin Property (Replication ActiveX)

PublisherNetwork Property (Replication ActiveX)

PublisherPassword Property (Replication ActiveX)

PublisherSecurityMode Property (Replication ActiveX)

QueryTimeout Property (Replication ActiveX)

Subscriber Property (Replication ActiveX)

SubscriberChanges Property (Replication ActiveX)

SubscriberConflicts Property (Replication ActiveX)

SubscriberDatabase Property (Replication ActiveX)

SubscriberDatabasePath Property (Replication ActiveX)

SubscriberDatasourceType Property (Replication ActiveX)

SubscriberLogin Property (Replication ActiveX)

SubscriberPassword Property (Replication ActiveX)

SubscriberSecurityMode Property (Replication ActiveX)

SubscriptionName Property (Replication ActiveX)

SubscriptionPriority Property (Replication ActiveX)

SubscriptionPriorityType Property (Replication ActiveX)

SubscriptionType Property (Replication ActiveX)

SynchronizationType Property (Replication ActiveX)

SyncToAlternate Property (Replication ActiveX)

UseInteractiveResolver Property (Replication ActiveX)

Validate Property (Replication ActiveX)

WorkingDirectory Property (Replication ActiveX)

Methods

AddSubscription Method (Replication ActiveX)

CopySubscription Method (Replication ActiveX)

DropSubscription Method (Replication ActiveX)

Initialize Method (Replication ActiveX)

IsSnapshotRequired Method (Replication ActiveX)

ReinitializeSubscription Method (Replication ActiveX)

Run Method (Replication ActiveX)

Terminate Method (Replication ActiveX)

Events

Status Event (Replication ActiveX)

Remarks

To refer to the elements of this object from a Microsoft Visual Basic application, in the Project/References dialog box, select Microsoft SQL Merge Control 9.0. In a C/C++ application, include Replmrgx.c and Sqlmergx.h, and reference Sqlmergx.dll from the project/NMAKE file.

See Also

Concepts

Programming Replication Using ActiveX Controls

Help and Information

Getting SQL Server 2005 Assistance