DistributionPublisher.WorkingDirectory DistributionPublisher.WorkingDirectory DistributionPublisher.WorkingDirectory Property

정의

게시할 데이터 및 스키마 파일을 저장하는 데 사용하는 작업 디렉터리의 이름을 가져오거나 설정합니다. Gets or sets the name of the working directory used to store data and schema files for the publication.

public:
 property System::String ^ WorkingDirectory { System::String ^ get(); void set(System::String ^ value); };
public string WorkingDirectory { get; set; }
Public Property WorkingDirectory As String
속성 값

응용 프로그램을 위한 데이터 및 스키마 파일을 저장하기 위해 사용되는 작업 디렉터리의 이름입니다. The name of the working directory used to store data and schema files for the application.

예제

// 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();
}
' Set the server and database names
Dim distributionDbName As String = "distribution"
Dim publisherName As String = publisherInstance
Dim publicationDbName As String = "AdventureWorks2012"

Dim distributionDb As DistributionDatabase
Dim distributor As ReplicationServer
Dim publisher As DistributionPublisher
Dim publicationDb As ReplicationDatabase

' Create a connection to the server using Windows Authentication.
Dim conn As ServerConnection = 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((CType(Nothing, String)), 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 ex As Exception
    ' Implement appropriate error handling here.
    Throw New ApplicationException("An error occured when installing distribution and publishing.", ex)

Finally
    conn.Disconnect()

End Try

설명

WorkingDirectory 의 구성원만 속성을 검색할 수는 sysadmin 배포자에서 고정된 서버 역할입니다.The WorkingDirectory property can only be retrieved by members of the sysadmin fixed server role at the Distributor.

WorkingDirectory 속성의 구성원으로 설정할 수 있습니다는 sysadmin 배포자에서 고정된 서버 역할입니다.The WorkingDirectory property can only be set by members of the sysadmin fixed server role at the Distributor.

검색 된 WorkingDirectory 속성은 실행 sp_helpdistpublisher합니다.Retrieving the WorkingDirectory property is equivalent to executing sp_helpdistpublisher.

설정의 WorkingDirectory 속성은 실행 sp_adddistpublisher 또는 sp_changedistpublisher합니다.Setting the WorkingDirectory property is equivalent to executing sp_adddistpublisher or sp_changedistpublisher.

적용 대상

추가 정보