Generating Publication Scripts
For anyone who has used Replication with SQL Server 6.x, the Scripts tab will be a welcome sight. SQL Server 2000's scripting utility allows you to generate a script that re-creates the entire publication (including articles, subscribers, filters, and so on). You can also generate a script that allows you to delete the publication as well as append the script to an existing file.
To create a replication script from Enterprise Manager, expand the Replication, and then the Publication folders. Right-click the publication, and select Generate SQL Script from the shortcut menu.
Using the script generator, you could create a single file that drops all your publications and then re-creates them. The capability to generate ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
