SQLDistribution Object (Replication ActiveX)
The SQL Distribution control is implemented as a Microsoft ActiveX in-process component. The SQL Distribution control provides an alternate way, in addition to the Distribution Agent, to control synchronization of transactional replication subscriptions. Its primary class, the SQLDistribution object, provides the functionality of the Distribution Agent and supports synchronization of push, pull, or anonymous subscriptions to a transactional publication. The SQLDistribution object also includes options to:
- Add or drop subscriptions.
- Specify an alternate snapshot folder, from which the initial snapshot for a subscription can be applied.
- Set the Subscriber update mode to use immediate or queued updating for changes made at the Subscriber.
.gif "ms147359.security(en-US,SQL.90).gif") Security Note: |
|---|
| The SQL Distribution control is designated as "not safe for scripting" and "not safe for initialization." |
Properties
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)
DTSPackageFileName Property (Replication ActiveX)
DTSPackagePassword Property (Replication ActiveX)
ErrorRecords Property (Replication ActiveX)
FileTransferType Property (Replication ActiveX)
FTPAddress Property (Replication ActiveX)
FTPLogin Property (Replication ActiveX)
FTPPassword Property (Replication ActiveX)
FTPPort Property (Replication ActiveX)
LastUpdatedTime Property (Replication ActiveX)
LoginTimeout Property (Replication ActiveX)
MaxDeliveredTransactions 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)
PublisherDatabase Property (Replication ActiveX)
PublisherLogin Property (Replication ActiveX)
PublisherNetwork Property (Replication ActiveX)
PublisherPassword Property (Replication ActiveX)
PublisherSecurityMode Property (Replication ActiveX)
QueryTimeout Property (Replication ActiveX)
SkipErrors Property (Replication ActiveX)
Subscriber 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)
SubscriptionType Property (Replication ActiveX)
SynchronizationType Property (Replication ActiveX)
UndeliveredCommands Property (Replication ActiveX)
UndeliveredTransactions Property (Replication ActiveX)
UseInProcLoader 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)
SetFailoverMode 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 Distribution Control 9.0. In a Microsoft Visual C++ application, include Repldstx.c and Sqldistx.h, and reference Sqldistx.dll from the project/NMAKE file.
See Also
Concepts
Programming Replication Using ActiveX Controls