Publication.Attributes 속성

참조

정의

네임스페이스:: Microsoft.SqlServer.Replication

어셈블리:: Microsoft.SqlServer.Rmo.dll

중요

일부 정보는 릴리스되기 전에 상당 부분 수정될 수 있는 시험판 제품과 관련이 있습니다. Microsoft는 여기에 제공된 정보에 대해 어떠한 명시적이거나 묵시적인 보증도 하지 않습니다.

게시 특성을 가져오거나 설정합니다.

public:
 property Microsoft::SqlServer::Replication::PublicationAttributes Attributes { Microsoft::SqlServer::Replication::PublicationAttributes get(); void set(Microsoft::SqlServer::Replication::PublicationAttributes value); };

public Microsoft.SqlServer.Replication.PublicationAttributes Attributes { get; set; }

member this.Attributes : Microsoft.SqlServer.Replication.PublicationAttributes with get, set

Public Property Attributes As PublicationAttributes

속성 값

PublicationAttributes

PublicationAttributes 열거 값입니다.

예제

// Set the Publisher, publication database, and publication names.
string publisherName = publisherInstance;
string publicationName = "AdvWorksSalesOrdersMerge";
string publicationDbName = "AdventureWorks2012";

ReplicationDatabase publicationDb;
MergePublication publication;

// Create a connection to the Publisher.
ServerConnection conn = new ServerConnection(publisherName);

try
{
    // Connect to the Publisher.
    conn.Connect();

    // Enable the database for merge publication.				
    publicationDb = new ReplicationDatabase(publicationDbName, conn);
    if (publicationDb.LoadProperties())
    {
        if (!publicationDb.EnabledMergePublishing)
        {
            publicationDb.EnabledMergePublishing = true;
        }
    }
    else
    {
        // Do something here if the database does not exist. 
        throw new ApplicationException(String.Format(
            "The {0} database does not exist on {1}.",
            publicationDb, publisherName));
    }

    // Set the required properties for the merge publication.
    publication = new MergePublication();
    publication.ConnectionContext = conn;
    publication.Name = publicationName;
    publication.DatabaseName = publicationDbName;

    // Enable Web synchronization, if not already enabled.
    if ((publication.Attributes & PublicationAttributes.AllowWebSynchronization) == 0)
    {
        publication.Attributes |= PublicationAttributes.AllowWebSynchronization;
    }

    // Enable pull subscriptions, if not already enabled.
    if ((publication.Attributes & PublicationAttributes.AllowPull) == 0)
    {
        publication.Attributes |= PublicationAttributes.AllowPull;
    }
    
    // Enable Subscriber requested snapshot generation. 
    publication.Attributes |= PublicationAttributes.AllowSubscriberInitiatedSnapshot;

    // Enable anonymous access for Subscribers that cannot make a direct connetion 
    // to the Publisher. 
    publication.Attributes |= PublicationAttributes.AllowAnonymous;

    // Specify the Windows account under which the Snapshot Agent job runs.
    // This account will be used for the local connection to the 
    // Distributor and all agent connections that use Windows Authentication.
    publication.SnapshotGenerationAgentProcessSecurity.Login = winLogin;
    publication.SnapshotGenerationAgentProcessSecurity.Password = winPassword;

    // Explicitly set the security mode for the Publisher connection
    // Windows Authentication (the default).
    publication.SnapshotGenerationAgentPublisherSecurity.WindowsAuthentication = true;

    if (!publication.IsExistingObject)
    {
        // Create the merge publication and the Snapshot Agent job.
        publication.Create();
        publication.CreateSnapshotAgent();
    }
    else
    {
        throw new ApplicationException(String.Format(
            "The {0} publication already exists.", publicationName));
    }
}

catch (Exception ex)
{
    // Implement custom application error handling here.
    throw new ApplicationException(String.Format(
        "The publication {0} could not be created.", publicationName), ex);
}
finally
{
    conn.Disconnect();
}

' Set the Publisher, publication database, and publication names.
Dim publisherName As String = publisherInstance
Dim publicationName As String = "AdvWorksSalesOrdersMerge"
Dim publicationDbName As String = "AdventureWorks2012"

Dim publicationDb As ReplicationDatabase
Dim publication As MergePublication

' Create a connection to the Publisher.
Dim conn As ServerConnection = New ServerConnection(publisherName)

Try
    ' Connect to the Publisher.
    conn.Connect()

    ' Enable the database for merge publication.				
    publicationDb = New ReplicationDatabase(publicationDbName, conn)
    If publicationDb.LoadProperties() Then
        If Not publicationDb.EnabledMergePublishing Then
            publicationDb.EnabledMergePublishing = True
        End If
    Else
        ' Do something here if the database does not exist. 
        Throw New ApplicationException(String.Format( _
         "The {0} database does not exist on {1}.", _
         publicationDb, publisherName))
    End If

    ' Set the required properties for the merge publication.
    publication = New MergePublication()
    publication.ConnectionContext = conn
    publication.Name = publicationName
    publication.DatabaseName = publicationDbName

    ' Enable Web synchronization, if not already enabled.
    If (publication.Attributes And PublicationAttributes.AllowWebSynchronization) = 0 Then
        publication.Attributes = publication.Attributes _
        Or PublicationAttributes.AllowWebSynchronization
    End If

    ' Enable pull subscriptions, if not already enabled.
    If (publication.Attributes And PublicationAttributes.AllowPull) = 0 Then
        publication.Attributes = publication.Attributes _
        Or PublicationAttributes.AllowPull
    End If

    ' Enable Subscriber requested snapshot generation. 
    publication.Attributes = publication.Attributes _
        Or PublicationAttributes.AllowSubscriberInitiatedSnapshot

    ' Enable anonymous access for Subscribers that cannot 
    ' make a direct connetion to the Publisher. 
    publication.Attributes = publication.Attributes _
        Or PublicationAttributes.AllowAnonymous

    ' Specify the Windows account under which the Snapshot Agent job runs.
    ' This account will be used for the local connection to the 
    ' Distributor and all agent connections that use Windows Authentication.
    publication.SnapshotGenerationAgentProcessSecurity.Login = winLogin
    publication.SnapshotGenerationAgentProcessSecurity.Password = winPassword

    ' Explicitly set the security mode for the Publisher connection
    ' Windows Authentication (the default).
    publication.SnapshotGenerationAgentPublisherSecurity.WindowsAuthentication = True

    If Not publication.IsExistingObject Then
        ' Create the merge publication and the Snapshot Agent job.
        publication.Create()
        publication.CreateSnapshotAgent()
    Else
        Throw New ApplicationException(String.Format( _
            "The {0} publication already exists.", publicationName))
    End If
Catch ex As Exception
    ' Implement custom application error handling here.
    Throw New ApplicationException(String.Format( _
        "The publication {0} could not be created.", publicationName), ex)
Finally
    conn.Disconnect()
End Try

설명

열거형은 PublicationAttributes 열거형 값의 비트 조합을 허용하는 옵션을 지원 FlagsAttribute 합니다. 트랜잭션 또는 스냅샷 게시 및 병합 게시의 기본 특성 값에 대한 자세한 내용은 sp_addpublication(Transact-SQL) 및 sp_addmergepublication(Transact-SQL)를 참조하세요.

게시 Attributes 자에서 고정 서버 역할의 멤버, 게시 데이터베이스의 sysadmin 고정 데이터베이스 역할 멤버 또는 PAL(게시 액세스 목록)의 db_owner 사용자만 속성을 검색할 수 있습니다.

속성은 Attributes 게시자에서 고정 서버 역할의 sysadmin 멤버 또는 게시 데이터베이스의 db_owner 고정 데이터베이스 역할 멤버에 의해서만 설정할 수 있습니다. PAL의 사용자는 기존 게시의 Attributes 속성을 설정할 수 있습니다.

속성을 검색하는 Attributes 것은 sp_helppublication 또는 sp_helpmergepublication 실행하는 것과 같습니다.

Attributes 속성을 설정하는 것은 sp_addpublication 실행 및 sp_changepublication 또는 sp_addmergepublication 및 sp_changemergepublication 것과 같습니다.

적용 대상

추가 정보

방법: 게시 만들기(RMO 프로그래밍)

다음을 통해 공유

Publication.Attributes 속성

정의

속성 값

예제

설명

적용 대상

추가 정보

추가 리소스