The ability to programmatically configure, maintain, and monitor a replication topology enables you to both simplify repeated replication tasks and improve the user experience for your replication-based applications. By programming replication, your end-users can be provided with customized replication functionalities without having to be familiar with replication stored procedures and replication agent executables or having to using the replication user interface implemented by Microsoft SQL Server Management Studio.
The following are scenarios in which your applications might benefit from programmatic access to replication services:
- Adding replication functionalities to an existing end-user application, such as synchronizing a pull subscription when the user clicks a button.
- Creating a Web-based user interface for remotely administering replication.
- Creating a custom user interface that exposes only a subset of administration functionality, can be used to remotely administer multiple replication topologies from a single location, or that combine administration and synchronization functionalities.
- Improving an existing monitoring tool by adding the ability to monitor the status of a publication, subscription, or at the Distributor.
- Creating a custom application to administer or synchronize subscriptions to an Oracle publisher.
- Writing customized business rules that are executed when a merge subscription is synchronized.
- Generating Transact-SQL scripts that can be run repeated when configuring new Subscribers.
SQL Server enables you to programmatically control replication agents and to programmatically administer and monitor a replication topology. To learn more about programming replication, see Planning for Replication Programming.