question

m0bilal avatar image
m0bilal asked

Reinitialization of subscription at Publisher vs Subscriber (Merge Replication)

I am new to SQL Replication and would like to know if there is any difference in reinitializing a subscription from Publisher or Subscriber? In other words, is there any difference if I:

A: On the Subscriber machine, Open SQL Server Management Studio, SQL server name is my_machine\SQLEXPRESS. Navigate to Replication > Local Subscriptions > Right click on my subscription > Click Reinitialize.

B: On Publisher Server, Open SQL Server Management Studio. Execute exec sp_reinitmergesubscription @publication = N'my_pub', @subscriber = N'my_machine\SQLEXPRESS', @subscriber_db = N'my_db', @upload_first = N'false'

Will A & B result in the same? My Server is SQL Server 2016 and my Subscriber is SQL Server 2012. I am using MergePullSubscription using Web Synchronization.

And why I am asking this is because when I go for option B and sync at the subscriber, it takes comparatively more time than if I go for option A and sync. With option A subscriber syncs within a minute, with option B it takes minutes.

sql-serverreplicationmerge-replicationsynchronisation
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.