74 0
Part V: Enterprise Data Management
- Click Next to advance to the Wizard options. Here you can specify whether you
want the snapshot created immediately, scripted, or both. - Click Finish to complete the dialog and create your subscription.
Creating a Pull Subscription to a Transactional/Snapshot
Publication
Creating a pull subscription is similar to creating a push subscription. The following steps
show you how:- Connect to your subscriber using SQL Server Management Studio, expand the
Replication folder, and then right-click the Local Subscriptions folder. - Select New Subscriptions, and click Next at the splash screen. In the drop-down
box, select your publisher, and then expand your publication database and select
your publication. - Click Next. In the Distribution Agent location dialog, select Run Each Agent at Its
Subscriber (Pull Subscriptions) and click Next. - Click the check box next to your subscriber, and select your subscription database
on the right side of the screen. Click Next to advance to the Distribution Agent
Security dialog. - Select the security context you want the binary to run under, and choose the
account you want to use to connect to the subscriber. This account should be in the
dbo_owner role on the subscriber. - Click Next. In the Synchronization Schedule dialog, choose how frequently you
want the subscriber to connect. The options are to run continuously, run on
demand, or run on a schedule. - Click Next to continue to the Initialize Subscriptions dialog. The options are to ini-
tialize your subscription immediately, at fi rst synchronization, or not to initialize
your subscription at all (by not selecting the initialize check box). Follow the notes
in Creating a Push Subscription for more details on this option. - Click Next to advance to the Wizard options. Here you can specify whether you
want the snapshot created immediately, scripted, or both. - Click Finish to complete the dialog and create your subscription.
Creating a Peer-to-Peer Topology
To create a peer-to-peer topology you must run the Enterprise Edition of SQL Server. Create
a transactional replication publication, and after you complete the publication creation,
right-click the publication in the Local Publications folder. In the Subscription Options tab,
ensure that Allow Peer-to-Peer Subscriptions is set to true. Click OK.c28.indd 740c28.indd 740 7/31/2012 9:51:13 AM7/31/2012 9:51:13 AM
http://www.it-ebooks.info