ReplicationServer.InstallDistributor Method


Installs a Distributor.

Namespace:   Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

System_CAPS_pubmethodInstallDistributor(SecureString, DistributionDatabase)

Installs a Distributor on the currently connected instance of Microsoft SQL Server, where the password is specified using a SecureString object.

System_CAPS_pubmethodInstallDistributor(String, DistributionDatabase)

Installs a Distributor on the currently connected instance of Microsoft SQL Server.

System_CAPS_pubmethodInstallDistributor(String, SecureString)

Registers a remote Distributor, where the password is specified using a SecureString object.

System_CAPS_pubmethodInstallDistributor(String, String)

Registers a remote Distributor.

// Set the server and database names
string distributionDbName = "distribution";
string publisherName = publisherInstance;
string publicationDbName = "AdventureWorks2012";

DistributionDatabase distributionDb;
ReplicationServer distributor;
DistributionPublisher publisher;
ReplicationDatabase publicationDb;

// Create a connection to the server using Windows Authentication.
ServerConnection conn = new ServerConnection(publisherName);

	// Connect to the server acting as the Distributor 
	// and local Publisher.

	// Define the distribution database at the Distributor,
	// but do not create it now.
	distributionDb = new DistributionDatabase(distributionDbName, conn);
	distributionDb.MaxDistributionRetention = 96;
	distributionDb.HistoryRetention = 120;

	// Set the Distributor properties and install the Distributor.
	// This also creates the specified distribution database.
	distributor = new ReplicationServer(conn);
	distributor.InstallDistributor((string)null, distributionDb);

	// Set the Publisher properties and install the Publisher.
	publisher = new DistributionPublisher(publisherName, conn);
	publisher.DistributionDatabase = distributionDb.Name;
	publisher.WorkingDirectory = @"\\" + publisherName + @"\repldata";
	publisher.PublisherSecurity.WindowsAuthentication = true;

	// Enable AdventureWorks2012 as a publication database.
	publicationDb = new ReplicationDatabase(publicationDbName, conn);

	publicationDb.EnabledTransPublishing = true;
	publicationDb.EnabledMergePublishing = true;
catch (Exception ex)
	// Implement appropriate error handling here.
	throw new ApplicationException("An error occured when installing distribution and publishing.", ex);
Return to top