Replication Developer Documentation

Applies to: SQL Server Azure SQL Managed Instance

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 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 Replication Programming Concepts.

In This Section

Replication Programming Concepts
Describes the planning steps to develop an application that uses replication.

Replication System Stored Procedures Concepts
Describes how system stored procedures can be used to proivide programmatic access in a replication topology.

Replication Management Objects Concepts
Explains the concepts for using Replication Management Objects (RMO). This is a managed code assembly that encapsulates replication functionalities for SQL Server.

Replication Agent Executables Concepts
Describes the use of Replication Agent Executable files.