Compartilhar via


Método ReplicationServer.InstallDistributor

Incluir membros protegidos
Incluir membros herdados

Installs a Distributor.

Esse membro está sobrecarregado. Para obter informações mais completas sobre esse membro, incluindo sintaxe, uso e exemplos, clique em um nome na lista de sobrecarga.

Lista de sobrecargas

  Nome Descrição
Método público InstallDistributor(SecureString, DistributionDatabase) Installs a Distributor on the currently connected instance of Microsoft SQL Server, where the password is specified using a SecureString object.
Método público InstallDistributor(String, DistributionDatabase) Installs a Distributor on the currently connected instance of Microsoft SQL Server.
Método público InstallDistributor(String, SecureString) Registers a remote Distributor, where the password is specified using a SecureString object.
Método público InstallDistributor(String, String) Registers a remote Distributor.

Início

Exemplos

           // 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);

            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 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);
            }
            finally
            {
                conn.Disconnect();
            }

Consulte também

Referência

ReplicationServer Classe

Namespace Microsoft.SqlServer.Replication