-- This script uses sqlcmd scripting variables. They are in the form -- $(MyVariable). For information about how to use scripting variables -- on the command line and in SQL Server Management Studio, see the -- "Executing Replication Scripts" section in the topic -- "Programming Replication Using System Stored Procedures". DECLARE @subscriptionDB AS sysname; DECLARE @publication AS sysname; SET @subscriptionDB = N'AdventureWorks2012Replica'; SET @publication = N'AdvWorksSalesOrdersMerge'; USE [AdventureWorks2012Replica] -- Execute at the Publisher to reinitialize the push subscription, -- and upload pending changes at the Subscriber. EXEC sp_reinitmergesubscription @subscriber = $(SubServer), @subscriber_db = @subscriptionDB, @publication = @publication, @upload_first = N'true'; GO -- Start the Merge Agent.