Getting Started with Replication Programming
Introducing Replication Programming
Benefits of Programming Replication
Planning for Replication Programming
Developing Replication Applications Using ActiveX Controls
Requirements for Using Replication ActiveX Controls in Development Environments
Requirements for Deploying Replication ActiveX Controls
Programming the SQL Snapshot ActiveX Control
Programming the SQL Distribution ActiveX Control
Programming the SQL Merge ActiveX Control
Common SQL Distribution Control and SQL Merge Control Functionality
Programming Replication ActiveX Controls Using VBScript
Replication ActiveX Control Reference
Object Model for ActiveX Controls
SQLSnapshot Object
SQLDistribution Object
SQLMerge Object
Other Replication Control Objects and Collections
AlternateSyncPartner Object
AlternateSyncPartners Collection
SQLReplError Object
SQLReplErrors Collection
Replication ActiveX Control Properties
AlternateSyncPartners Property
AltSnapshotFolder Property
Count Property
Description Property
Distributor Property
DistributorAddress Property
DistributorLogin Property
DistributorNetwork Property
DistributorPassword Property
DistributorSecurityMode Property
DTSPackageFileName Property
DTSPackagePassword Property
DynamicFilterHostName Property
DynamicFilterLogin Property
DynamicSnapshotLocation Property
ErrorNumber Property
ErrorNumberString Property
ErrorRecords Property
ExchangeType Property
FileTransferType Property
FriendlyName Property
FTPAddress Property
FTPLogin Property
FTPPassword Property
FTPPort Property
HostName Property
LoginTimeout Property
MaxDeliveredTransactions Property
ProfileName Property
Publication Property
Publisher Property
PublisherAddress Property
PublisherChanges Property
PublisherConflicts Property
PublisherDatabase Property
PublisherLogin Property
PublisherNetwork Property
PublisherPassword Property
PublisherRPCLogin Property
PublisherRPCPassword Property
PublisherRPCSecurityMode Property
PublisherSecurityMode Property
QueryTimeout Property
ReplicationType Property
SkipErrors Property
Source Property
SourceType Property
Subscriber Property
SubscriberChanges Property
SubscriberConflicts Property
SubscriberDatabase Property
SubscriberDatabasePath Property
SubscriberDatasourceType Property
SubscriberLogin Property
SubscriberPassword Property
SubscriberSecurityMode Property
SubscriptionName Property
SubscriptionPriority Property
SubscriptionPriorityType Property
SubscriptionType Property
SynchronizationType Property
SyncToAlternate Property
UndeliveredCommands Property
UndeliveredTransactions Property
UseInteractiveResolver Property
Validate Property
WorkingDirectory Property
Replication ActiveX Control Methods
Add Method
AddReplError Method
AddSubscription Method
CopySubscription Method
DropSubscription Method
Initialize Method
ReinitializeSubscription Method
Run Method
SetFailoverMode Method
Terminate Method
Replication ActiveX Control Events
Notify Event
Status Event
Replication ActiveX Control Constants
AGENT_STATUS
DATASOURCE_TYPE
DBADDOPTION
DBDROPOPTION
ERRORSOURCE_TYPE
EXCHANGE_TYPE
FILE_TRANSFER_TYPE
NETWORK_TYPE
REPL_FAILOVER_MODE
REPLICATION_TYPE
REPLRPC_SECURITY_TYPE
SECURITY_TYPE
STATUS_RETURN_CODE
SUBSCRIPTION_HOST
SUBSCRIPTION_PRIORITY_TYPE
SUBSCRIPTION_TYPE
SYNCHRONIZATION_TYPE
VALIDATE_TYPE
Developing Replication Merge Conflict Resolvers Through a Custom Resolver
COM Conflict Resolver Header File
Programming Replication from Heterogeneous Data Sources
SQL-DMO Replication Objects
Replication Distributor Interface Reference
Replication Distributor Interface Objects
DistributionLog Object
DistributionStore Object
Replication Distributor Interface Properties
DBPROP_APPLICATION_NAME Property
DBPROP_APPLICATION_TYPE Property
DBPROP_AUTH_PASSWORD Property
DBPROP_AUTH_USERID Property
DBPROP_DBMSNAME Property
DBPROP_DBMSVER Property
DBPROP_INIT_DATASOURCE Property
DBPROP_INIT_LOCATION Property
DBPROP_INIT_PUBLISHERDATASOURCE Property
DBPROP_INIT_PUBLISHER_NAME Property
DBPROP_INIT_TIMEOUT Property
DBPROP_INIT_XACT_SEQNO_SIZE Property
DBPROP_INIT_XACTID_SIZE Property
DBPROP_PUBLICATION_NAME Property
Replication Distributor Interface Methods
Abort Method
AddLog Method
AddTransactionCommands Method
Commit Method
GetLastTransaction Method
StartTransaction Method
Replication Distributor Interface Structures
DISTCOMMANDDESC Structure
CommandType Text Formats
DISTERRORDESC Structure
Replication Programming Samples
Replication Syntax Conventions
Replication ActiveX Control Samples
Using SQL Merge and SQL Distribution Controls in a Custom Visual Basic Application
Using SQL Merge and SQL Distribution Controls in a Custom Visual C++ Application
Using SQL Merge and SQL Distribution Controls in a Web Application
Creating a Transformable Subscription Using Visual Basic
Merge Replication Samples
Subscriber-Based Resolver Using C++ and a Stored Procedure
Transact-SQL Custom Stored Procedure Resolver
Generating Merge Dynamic Snapshot Jobs
Replication Distributor Interface Samples
Programming Snapshot or Transactional Replication from Heterogeneous Data Sources