Microsoft® SQL Server® 2012 Bible

738

Part V: Enterprise Data Management

FIGURE 28-2

The Snapshot Agent Security dialog.

After you create your publication, you can now create one or more subscriptions to it.

Creating a Push Subscription to a Transactional/Snapshot

Publication

The previous two sections discussed the two ways of replicating data: push and pull.

This section focuses on how to create push subscriptions to transactional and snapshot

publications:

1. Connect to your publisher in SQL Server Management Studio, and expand the
   Replication folder and the Local Publications folder.


2. Locate your publication, right-click it, and select New Subscriptions. Click Next to
   exit the splash screen.


3. In the Publication dialog, ensure that the publication you want to create a sub-
   scription to is highlighted. If it is not already selected, do so now; you may need
   to expand other databases to fi nd it. When your publication is highlighted, click
   Next.


4. In the distribution Agent Location dialog, accept the default, which is Run
   All Agents on the Distributor, MySQLServerName (push subscriptions), where
   MySQLServerName is the name of your publisher.

c28.indd 738c28.indd 738 7/31/2012 9:51:13 AM7/31/2012 9:51:13 AM

http://www.it-ebooks.info