ReplicationServer.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.
맨 위로 이동

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

커뮤니티 추가 항목

추가
표시: