HOW TO: Program the SQL Merge Control by Using Visual C# .NET

using System;
using System.Runtime.InteropServices;
using SQLMERGXLib;

namespace SqlRepl
{
	//This class demonstrates using the SQL Server Merge Agent replication control.
	class MergeApp
	{
		/*	Prior to running this code, replication needs to be setup as follows:
		// 	
		//		Create a merge publication called "SampleMergePublication" and configure it to allow pull
		//		subscriptions. 
		//		
		//	This code will first generate the snapshot. Then the subscription database
		//	and pull subscription will be created through code. Then the snapshot will be applied at the subscriber using
		//	the SQLMergeClass object.
		// 
		//	You will also need to set a reference to the following COM dll:
		//		-Microsoft SQL Merge Control 8.0	 
		*/ 
		
		[STAThread]
		static void Main(string[] args)
		{
			string strPublisher, strDistributor, strSubscriber, strPublisherDatabase, strSubscriberDatabase, strPublication;

			strPublisher = "PUBLISHER";		//change to the name of your publisher
			strDistributor = "DISTRIBUTOR";	//change to the name of your distributor
			strSubscriber = "SUBSCRIBER";		//change to the name of your subscriber
			strPublication = "SampleMergePublication";
			strPublisherDatabase = "Northwind";
			strSubscriberDatabase = "Northwind_replica";

			SQLMergeClass oMerge = new SQLMergeClass();
			
			//Set up the Publisher.
			oMerge.Publisher = strPublisher;
			oMerge.PublisherSecurityMode = SQLMERGXLib.SECURITY_TYPE.NT_AUTHENTICATION;
			oMerge.PublisherDatabase = strPublisherDatabase;
			oMerge.Publication = strPublication;

			//Set up the Distributor.
			oMerge.Distributor = strDistributor;
			oMerge.DistributorSecurityMode = SQLMERGXLib.SECURITY_TYPE.NT_AUTHENTICATION;
			
			//Set up the Subscriber.
			oMerge.Subscriber = strSubscriber;
			oMerge.SubscriberDatabase = strSubscriberDatabase;
			oMerge.SubscriberSecurityMode = SQLMERGXLib.SECURITY_TYPE.NT_AUTHENTICATION;

			//Set up the subscription.
			oMerge.SubscriptionType = SQLMERGXLib.SUBSCRIPTION_TYPE.PULL;
			oMerge.SynchronizationType = SQLMERGXLib.SYNCHRONIZATION_TYPE.AUTOMATIC;
			oMerge.SubscriptionName = "PullMergeSubscription";

			//Create the database and subscription.
			oMerge.AddSubscription(SQLMERGXLib.DBADDOPTION.CREATE_DATABASE, SQLMERGXLib.SUBSCRIPTION_HOST.NONE);
			
			//Synchronize the subscription.

			try
			{
				Console.WriteLine("Starting synchronization...");
				oMerge.Initialize();
				oMerge.Run();
				oMerge.Terminate();
				Console.WriteLine("Synchronization completed.");
			}
			catch (Exception e)
			{
				Console.WriteLine(e.StackTrace);
				Console.WriteLine(e.Message);
			}
		}
	}
}