PullSubscription.PublicationDBName PullSubscription.PublicationDBName PullSubscription.PublicationDBName Property

정의

게시 데이터베이스의 이름을 가져오거나 설정합니다. Gets or sets the name of the publication database.

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

게시가 정의된 데이터베이스의 이름을 지정하는 String 값입니다. A String value that specifies the name of the database where the publication is defined.

예제

// Define the Publisher, publication, and databases.
string publicationName = "AdvWorksProductTran";
string publisherName = publisherInstance;
string subscriberName = subscriberInstance;
string subscriptionDbName = "AdventureWorks2012Replica";
string publicationDbName = "AdventureWorks2012";

//Create connections to the Publisher and Subscriber.
ServerConnection subscriberConn = new ServerConnection(subscriberName);
ServerConnection publisherConn = new ServerConnection(publisherName);

// Create the objects that we need.
TransPublication publication;
TransPullSubscription subscription;

try
{
	// Connect to the Publisher and Subscriber.
	subscriberConn.Connect();
             publisherConn.Connect();

	// Ensure that the publication exists and that 
	// it supports pull subscriptions.
	publication = new TransPublication();
	publication.Name = publicationName;
	publication.DatabaseName = publicationDbName;
	publication.ConnectionContext = publisherConn;

	if (publication.IsExistingObject)
	{
		if ((publication.Attributes & PublicationAttributes.AllowPull) == 0)
		{
			publication.Attributes |= PublicationAttributes.AllowPull;
		}

		// Define the pull subscription.
		subscription = new TransPullSubscription();
		subscription.ConnectionContext = subscriberConn;
		subscription.PublisherName = publisherName;
		subscription.PublicationName = publicationName;
		subscription.PublicationDBName = publicationDbName;
		subscription.DatabaseName = subscriptionDbName;

		// Specify the Windows login credentials for the Distribution Agent job.
		subscription.SynchronizationAgentProcessSecurity.Login = winLogin;
		subscription.SynchronizationAgentProcessSecurity.Password = winPassword;

		// Make sure that the agent job for the subscription is created.
		subscription.CreateSyncAgentByDefault = true;

                 // By default, subscriptions to transactional publications are synchronized 
                 // continuously, but in this case we only want to synchronize on demand.
                 subscription.AgentSchedule.FrequencyType = ScheduleFrequencyType.OnDemand;

                 // Create the pull subscription at the Subscriber.
		subscription.Create();

		Boolean registered = false;

		// Verify that the subscription is not already registered.
		foreach (TransSubscription existing
			in publication.EnumSubscriptions())
		{
			if (existing.SubscriberName == subscriberName
				&& existing.SubscriptionDBName == subscriptionDbName)
			{
				registered = true;
			}
		}
		if (!registered)
		{
			// Register the subscription with the Publisher.
			publication.MakePullSubscriptionWellKnown(
				subscriberName, subscriptionDbName,
				SubscriptionSyncType.Automatic,
				TransSubscriberType.ReadOnly);
		}
	}
	else
	{
		// Do something here if the publication does not exist.
		throw new ApplicationException(String.Format(
			"The publication '{0}' does not exist on {1}.",
			publicationName, publisherName));
	}
}
catch (Exception ex)
{
	// Implement the appropriate error handling here.
	throw new ApplicationException(String.Format(
		"The subscription to {0} could not be created.", publicationName), ex);
}
finally
{
	subscriberConn.Disconnect();
	publisherConn.Disconnect();
}
' Define the Publisher, publication, and databases.
Dim publicationName As String = "AdvWorksProductTran"
Dim publisherName As String = publisherInstance
Dim subscriberName As String = subscriberInstance
Dim subscriptionDbName As String = "AdventureWorks2012Replica"
Dim publicationDbName As String = "AdventureWorks2012"

'Create connections to the Publisher and Subscriber.
Dim subscriberConn As ServerConnection = New ServerConnection(subscriberName)
Dim publisherConn As ServerConnection = New ServerConnection(publisherName)

' Create the objects that we need.
Dim publication As TransPublication
Dim subscription As TransPullSubscription

Try
    ' Connect to the Publisher and Subscriber.
    subscriberConn.Connect()
    publisherConn.Connect()

    ' Ensure that the publication exists and that 
    ' it supports pull subscriptions.
    publication = New TransPublication()
    publication.Name = publicationName
    publication.DatabaseName = publicationDbName
    publication.ConnectionContext = publisherConn

    If publication.IsExistingObject Then
        If (publication.Attributes And PublicationAttributes.AllowPull) = 0 Then
            publication.Attributes = publication.Attributes _
            Or PublicationAttributes.AllowPull
        End If

        ' Define the pull subscription.
        subscription = New TransPullSubscription()
        subscription.ConnectionContext = subscriberConn
        subscription.PublisherName = publisherName
        subscription.PublicationName = publicationName
        subscription.PublicationDBName = publicationDbName
        subscription.DatabaseName = subscriptionDbName
        subscription.Description = "Pull subscription to " + publicationDbName _
        + " on " + subscriberName + "."

        ' Specify the Windows login credentials for the Distribution Agent job.
        subscription.SynchronizationAgentProcessSecurity.Login = winLogin
        subscription.SynchronizationAgentProcessSecurity.Password = winPassword

        ' Make sure that the agent job for the subscription is created.
        subscription.CreateSyncAgentByDefault = True

        ' By default, subscriptions to transactional publications are synchronized 
        ' continuously, but in this case we only want to synchronize on demand.
        subscription.AgentSchedule.FrequencyType = ScheduleFrequencyType.OnDemand

        ' Create the pull subscription at the Subscriber.
        subscription.Create()

        Dim registered As Boolean = False

        ' Verify that the subscription is not already registered.
        For Each existing As TransSubscription In publication.EnumSubscriptions()
            If existing.SubscriberName = subscriberName And _
                existing.SubscriptionDBName = subscriptionDbName Then
                registered = True
            End If
        Next existing
        If Not registered Then
            ' Register the subscription with the Publisher.
            publication.MakePullSubscriptionWellKnown( _
             subscriberName, subscriptionDbName, _
             SubscriptionSyncType.Automatic, _
             TransSubscriberType.ReadOnly)
        End If
    Else
        ' Do something here if the publication does not exist.
        Throw New ApplicationException(String.Format( _
         "The publication '{0}' does not exist on {1}.", _
         publicationName, publisherName))
    End If
Catch ex As Exception
    ' Implement the appropriate error handling here.
    Throw New ApplicationException(String.Format( _
        "The subscription to {0} could not be created.", publicationName), ex)
Finally
    subscriberConn.Disconnect()
    publisherConn.Disconnect()
End Try

설명

PublicationDBName 필수 속성 이며 서버에서 구독을 만들기 전에 설정 해야 합니다.PublicationDBName is a required property and must be set before the subscription is created on the server. 구독 등록 서버에 있으면는 PublicationDBName 속성을 변경할 수 없습니다.Once the subscription registration exists on the server, the PublicationDBName property cannot be changed.

PublicationDBName 의 구성원만 속성을 검색할 수는 sysadmin 고정된 서버 역할의 멤버 또는 구독자에서의 db_owner 구독 데이터베이스의 고정된 데이터베이스 역할입니다.The PublicationDBName property can only be retrieved by members of the sysadmin fixed server role at the Subscriber or by members of the db_owner fixed database role on the subscription database.

PublicationDBName 속성의 구성원으로 설정할 수 있습니다는 sysadmin 고정된 서버 역할의 멤버 또는 구독자에서의 db_owner 구독 데이터베이스의 고정된 데이터베이스 역할입니다.The PublicationDBName property can only be set by members of the sysadmin fixed server role at the Subscriber or by members of the db_owner fixed database role on the subscription database.

검색 하는 PublicationDBName 속성은 실행 sp_helppullsubscription (Transact SQL) 또는 sp_helpmergepullsubscription (Transact SQL)합니다.Retrieving the PublicationDBName property is equivalent to executing sp_helppullsubscription (Transact-SQL) or sp_helpmergepullsubscription (Transact-SQL).

설정의 PublicationDBName 속성은 실행 sp_addpullsubscription (Transact SQL) 또는 sp_addmergepullsubscription (Transact SQL)합니다.Setting the PublicationDBName property is equivalent to executing sp_addpullsubscription (Transact-SQL) or sp_addmergepullsubscription (Transact-SQL).

적용 대상

추가 정보