Tuesday, March 27, 2012

Step By Step Guide to Subscribing a Merge Publication

About Merge Replication:
Through SQL Server Snapshot Agent and Merge Agent the Merge replication will be implemented. If the publication is unfiltered or uses static filters, the Snapshot Agent creates a single snapshot. If the publication uses parametrized filters, the Snapshot Agent creates a snapshot for each partition of data. 

The Merge Agent applies the initial snapshots to the Subscribers. It also merges incremental data changes that occurred at the Publisher or Subscribers after the initial snapshot was created, and detects and resolves any conflicts according to rules you configure. 

Step By Step guide to Subscribing a Merge Publication:
Step 1.        Go to Start menu click run and type SSMS and open SQL Server Management Studio. Expand Replication, right-click on Local Subscriptions, and click New Subscription. 

Step 2.       Now it will brings you to the New Subscription Wizard welcome screen. Click Next to continue. 

Step 3.        On the Publication screen, select the default instance of your server from the Publisher drop-down list. Select Merg_Pub from the Databases and Publications list, and click Next to continue.

Step 4.       On the Merge Agent Location screen, you are asked choose where to run the merge Agent(s) at the distributor or at the subscriber. If you want to create a pull subscription, select the Run Each Agent at Its Subscriber option, and click Next.

Step 5.       On the Subscribers screen, you can choose a subscriber for the publication. Check the box next to your server. Then the drop-down list is populated with all the available databases on the subscriber. Select New Database from the list to open the New Database dialog box.

Step 6.        Enter Merge_DB in the Database Name box, and click OK. Then click Next.

Step 7.        Now merge agent security. To do so, click the ellipsis (…) button in the Subscription Properties list.

Step 8.         usually you have to create an account for the agent to run under, but here to make it simple, you will run the agent using the SQL Server Agent account, so select the radio button for that option, and click OK. Back at the Merge Agent Security screen, click Next to continue.

Step 9.         The next step is to set the synchronization schedule, so select Define Schedule.

Step 10.        In the New Job Schedule dialog box, make these changes:- Under Frequency, set Occurs to Daily. Under Daily Frequency, select Occurs Every, and set the interval to 10 minutes and Click OK.

Step 11.         Back at the Synchronization Schedule screen, click Next.

Step 12.         On the next screen, you can tell SQL Server when to initialize the subscription. you should select Immediately from the drop-down list, make sure the Initialize box is checked, and click Next to continue.

Step 13.         The next screen shows you how conflicts will be resolved when they occur. In this case, select the defaults, and click Next.

Step 14.         On the Wizard Actions screen, you can have the wizard create the subscription, write a script to create the subscription that you can run later, or do both. Leave the Create the Subscription box checked, and click Next to continue.

Step 15.          On the Complete the Wizard screen, review your options, and click Finish to create the subscription. When the wizard is finished, click Close.

How to track changes In Merge Replication. merge replication step by step. Step by Step Guide to Merge Replication. sql server Merge Replication step by step. sql server step by step replication ebook. microsoft sql server step by step replication ebook. sql server replication step by step tutorial. step by step installation of sql replication. pdf. microsoft sql server 2008 replication step by step. What is Snapshot Replication. how to create merge publication. Create a Snapshot for a Merge Publication with Parameterized Filters. How Merge Replication Works. Print merged publications. How Merge Replication Works. sql server 2012 Merge Replication Step by Step Procedure. sql server 2008 Merge Replication Step by Step Procedure. Setting Up Merge Replication. When to use SQL Server Merge Replication. merge replication advantages. merge replication disadvantages. SQL Server Merge Replication Best Practices. in sql server 2005. merge replication sql server 2008 step by step. merge replication sql server 2008. merge replication sql server 2000. merge replication sql server 2008 r2. transactional replication sql server. merge replication error. data loss in merge replication. updated sql server 2005 bug alert.


Post a Comment