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.
See Also