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.
