Scripting (Replication)

Transact-SQL scripts can be used to automate repetitive tasks in configuring and maintaining replication. Nearly all replication tasks can be scripted using replication system stored procedures. All replication components in a topology should be scripted as part of a disaster recovery plan.

The following topics provide information about scripting replication:

Scripting Replication

Provides a basic overview of scripting to automate replication and as part of a disaster recovery plan.

Replication System Stored Procedures Concepts

Provides information about programmatically configuring a replication topology using scripting.

How to: Script Replication Objects (SQL Server Management Studio)

Provides step-by-step information about how to use SQL Server Management Studio to generate scripts to re-create an existing replication topology.

How to: Upgrade Replication Scripts (Replication Transact-SQL Programming)

Provides step-by-step information about how to upgrade replication scripts from SQL Server 2000.