InstallDistributor 方法
Installs a Distributor.
此成员被重载。有关此成员的完整信息,包括语法、用法和示例,请单击重载列表中的名称。
重载列表
名称 | 说明 | |
---|---|---|
InstallDistributor(SecureString, DistributionDatabase) | Installs a Distributor on the currently connected instance of Microsoft SQL Server, where the password is specified using a SecureString object. | |
InstallDistributor(String, DistributionDatabase) | Installs a Distributor on the currently connected instance of Microsoft SQL Server. | |
InstallDistributor(String, SecureString) | Registers a remote Distributor, where the password is specified using a SecureString object. | |
InstallDistributor(String, String) | Registers a remote Distributor. |
页首
注释
This namespace, class, or member is supported only in version 2.0 of the .NET Framework.
示例
// Set the server and database names
string distributionDbName = "distribution";
string publisherName = publisherInstance;
string publicationDbName = "AdventureWorks";
DistributionDatabase distributionDb;
ReplicationServer distributor;
DistributionPublisher publisher;
ReplicationDatabase publicationDb;
// Create a connection to the server using Windows Authentication.
ServerConnection conn = new ServerConnection(publisherName);
try
{
// Connect to the server acting as the Distributor
// and local Publisher.
conn.Connect();
// 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;
publisher.Create();
// Enable AdventureWorks 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);
}
finally
{
conn.Disconnect();
}