Creating Subscriptions
From SQLServerPedia
|
See Also: Main_Page - Database Administration - Replication To create subscriptions to your publications connect to your Subscriber and expand the replication folder. Right click on the Local Subscriptions folder and select New Subscriptions. Click Next at the New Subscription Wizard dialog box. Select the Publisher in the Publisher drop down box, which contains the publications you wish to subscribe to. Expand the publication database, locate the publication you wish to subscriber to, click on it to give it focus, and then click Next. Select whether you wish to use Pull Subscriptions or Push Subscriptions. In general:
Otherwise use push subscriptions. Click Next to launch the Subscribers dialog box. Check the servers you wish to make subscribers of this publication, and in the subscription database section, click on the drop down box to select the subscription database. You have the option of adding subscribers which do not appear in this list by clicking on the Add Subscriber button. Click on the Next button to launch the Distribution Agent Security dialog box. Click Next to launch the Synchronization Schedule dialog box. In the Agent Schedule drop down box, select whether you want the agent to run continuously, on demand (by Windows Synchronization Manager), or on a schedule. Click Next to launch the Initialize Subscriptions dialog box. Note that if your publication supports Updateable Subscriptions you will get the Updateable Subscriptions dialog box before you get the Initialize Subscriptions dialog box. In the Commit at Published drop down box, Select Simultaneously commit changes if you wish to use immediate updating, or chose Queue Change and commit where possible if you wish to use Queue Updating. You will then get a dialog to enter account information for the linked server used by the Updatable Subscribers. You can create an account to use here, or select to use an existing linked server between the Subscriber and Publisher. Click Next to launch the Initialize Subscriptions dialog box. If you have deployed your subscription from a backup or have manually created the subscription database with the schema and data of the objects you wish to replicate to. Otherwise select immediately if you wish to immediately send the snapshot to the Subscriber; select at first synchronization if you wish to control when the snapshot will be applied. Click Next to launch the Wizard Actions. If you are subscribing to a merge publication you will get a Subscription Type dialog box before the Initialize Subscriptions dialog box. The Subscription Type dialog allows you to set the priority on your subscription as well as the subscription type. If you select a client subscription type, the first subscriber merging with the publisher wins a conflict. If you select a server subscription type you can select a priority to assign to the subscriber. By assigning different priorities to different servers you are replicating to, you can control which server will win a conflict. Clicking on Next will launch the Initialize Subscriptions dialog box. This will allow you to either immediately create the subscription, to script it for later deployment, or to do both. If you have selected to immediately create the snapshot you will get the subscription summary dialog box; if you have selected to script the subscription you will get the Script File Properties dialog box, which prompts you to enter a name and location of where you wish to generate your subscription creation script. Click Finish to create your subscription and/or generate your subscription script. You can check the status of your subscription creation or script creation in the Creating Subscriptions dialog box. Click Close upon completion of the actions. You may wish to Right click on your subscription in the Local Subscription folder and select View Subscription Status to check on the deployment of your subscription. |