SQL Server Replication Configuration – Part 5

Hi Folks,

You might have seen my last article-post which was about – How to create a Pull Subscription to a Transactional or Snapshot Replication. If you want to refer it, then here’s the link;

In this article-post, I would like to deal with the Creation of Merge Publication.

Creating a Merge Publication:

What is Merge Publication?

The Publisher and Subscribers can update the published data independently after the Subscribers receive an initial snapshot of the published data. Changes are merged periodically. Microsoft SQL Server Compact Edition can only subscribe to merge publications.

The creation of Merge Publication is very much similar to Snapshot or Transactional Publications. Therefore, follow the steps to create a merge publication:

Step 1: Connect to the Publisher using SQL Server Management Studio. Now expand the Replication folder, and so right-click on this and select the “New Publication”.

1_SQL_Server_Configuring_the_Replication_Part5

Step 2:  In the New Publication Wizard, Click Next.

Step 3: Publication Database. Choose the database that contains the data or objects you want to publish. For e.g. I have chosen “School” database.

Step 4: Publication Type. Choose the Publication Type that best supports the requirements of your application. I have chosen here Merge Publication.

2_SQL_Server_Configuring_the_Replication_Part5

Step 5: Subscriber Types. Here you have to specify the SQL Server versions that would be used by the Subscribers to this Publication. You can also select multiple subscriber types.

3_SQL_Server_Configuring_the_Replication_Part5

Step 6: Now comes the Articles dialog, so you can choose what you want to replicate like tables, views, stored procedures, functions, or simply columns from the desired table.

4_SQL_Server_Configuring_the_Replication_Part5

Step 7: Article Issues. UniqueIdentifier columns will be added to the tables. SQL Server adds a uniqueidentifier column to published tables that do not have one when the first snapshot is generated.

5_SQL_Server_Configuring_the_Replication_Part5

Step 8: Filter Table Rows. Click on the Add to begin filtering your Publication.

Now in the Add Filter form, select the table which you want to filter. Under that which column you want to filter and the last thing is the Filter statement.

You have also the option to specify the filtered row, whether it would go to multiple subscriptions or single subscriptions.

6_SQL_Server_Configuring_the_Replication_Part5

Now just click Next.

Step 9: Now specify when to run the Snapshot Agent.

7_SQL_Server_Configuring_the_Replication_Part5

Step 10: Agent Security. Now for each agent specify the account under which it will run and its connection. Click the Next button.

Step 11: Now choose what happens when you click finish.

8_SQL_Server_Configuring_the_Replication_Part5

Step 12: Now at-last give the publication name, and click on the Finish button.

 

Well this all about how we configure Merge Publication.

And also comments on this!!

 

Regards

Piyush Bajaj

Like us on FaceBook Follow us on Twitter | Join the fastest growing SQL Server group on FaceBook

Follow me on Twitter  |  Follow me on FaceBook

 
Data Platform Virtual Summit 2020

Subscribe to SQLServerGeeks YouTube channel. If you want more learning content in your inbox, subscribe to SQLServerGeeks Bulletin.

SQLServerGeeks YouTube | SQLServerGeeks Bulletin | SQLServerGeeks Twitter

Avatar

About Piyush Bajaj

I am very passionate about SQL Server. I also did certification on MCSA – SQL Server 2012, Querying and Administering; MCTS – SQL Server 2008, Database Development; and MCTS – SQL Server 2005, Implementation & Maintenance, which helped me to get more knowledge and interest on this field.Please feel free to drop me any question online or offline, I will try to give you the best possible answer from my side.Right now I am working as a SQL Server developer in TCS. I have an experience of just 2.6 years, well I can only say that “If you have an interest and passion, experience might become a very small thing”.

View all posts by Piyush Bajaj →

Leave a Reply

Your email address will not be published. Required fields are marked *