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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.