Scripting Replication
Earlier, it was suggested that you 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. The easiest way to get to SQL scripting is by right-clicking on either the replication or publications folder and choosing Generate SQL Script. This Generate SQL Script dialog is shown in Figure 7.40. Use this option!
Figure 7.40. Scripting replication dialog and options via the publisher.
You can choose to have Enterprise Manager generate the creation (build up) of your data replication configuration and then have it generate the ...
Get Microsoft® SQL Server High Availability 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.
