Scripting Replication
Earlier, it was suggested to generate SQL Scripts for all that you do because going through wizards every time you have to configure replication is no way to run a production environment. An option in the Configure and Manage Data Replication screen allows you to generate SQL scripts. Use this option! Next is an example of the SQL scripts needed to generate the same data replication configuration that we just built with wizards. These scripts minimize the errors we will make while supporting our data replication environments.
use master GO exec sp_adddistributor @distributor = 'C81124-C\DBARCH01', @password ='' GO -- Adding the distribution database exec sp_adddistributiondb @database = 'distribution', @data_folder = 'd:\MSSQL2000\data', ...
Get Microsoft® SQL Server™ 2000 Unleashed, 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.
