Developing Replication Applications Using ActiveX Controls
Microsoft® SQL Server™ 2000 provides Microsoft ActiveX® controls that allow custom applications to embed replication functionality. These controls support synchronization and limited administration of push, pull, and anonymous subscriptions. In addition, these controls can be programmed to add, copy, and delete both pull and anonymous subscriptions; create or attach subscription databases; and create new subscriptions to be synchronized. The activity of these controls can be monitored using Replication Monitor in SQL Server Enterprise Manager.
Software developers can use ActiveX replication controls like any standard built-in control. They have been implemented as in-process components and do not have visible user interfaces. The ActiveX replication controls provided are:
- SQL Snapshot control
- SQL Distribution control
- SQL Merge control
These controls are comparable to the replication agents of the same name. The SQL Snapshot control has functions similar to the Snapshot Agent, the SQL Distribution control has functions similar to the Distribution Agent, and the SQL Merge control has functions similar to the Merge Agent.
The Microsoft SQL Server CD-ROM ships with some ActiveX replication control samples. For more information, see Replication ActiveX Control Samples.