TransPullSubscription.Reinitialize 메서드

Marks the pull subscription for reinitialization.

네임스페이스:  Microsoft.SqlServer.Replication
어셈블리:  Microsoft.SqlServer.Rmo(Microsoft.SqlServer.Rmo.dll)

public void Reinitialize()

After calling the Reinitialize method, you must start synchronization to reinitialize the subscription. For more information, see 방법: 구독 다시 초기화(RMO 프로그래밍).

The Reinitialize method can only be called by members of sysadmin fixed server role at the Subscriber or by members of the db_owner fixed database role on the subscription database.

Calling Reinitialize is equivalent to executing sp_reinitpullsubscription.

			// Define server, publication, and database names.
			String subscriberName = subscriberInstance;
			String publisherName = publisherInstance;
			String publicationName = "AdvWorksProductTran";
			String publicationDbName = "AdventureWorks2012";
            String subscriptionDbName = "AdventureWorks2012Replica";

			// Create a connection to the Subscriber.
			ServerConnection conn = new ServerConnection(subscriberName);

			TransPullSubscription subscription;

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

				// Define subscription properties.
				subscription = new TransPullSubscription();
				subscription.ConnectionContext = conn;
                subscription.DatabaseName = subscriptionDbName;
				subscription.PublisherName = publisherName;
				subscription.PublicationDBName = publicationDbName;
				subscription.PublicationName = publicationName;

				// If the pull subscription and the job exists, mark the subscription
				// for reinitialization and start the agent job.
				if (subscription.LoadProperties() && subscription.AgentJobId != null)
				{
					subscription.Reinitialize();
					subscription.SynchronizeWithJob();
				}
				else
				{
					// Do something here if the subscription does not exist.
					throw new ApplicationException(String.Format(
						"A subscription to '{0}' does not exists on {1}",
						publicationName, subscriberName));
				}
			}
			catch (Exception ex)
			{
				// Do appropriate error handling here.
				throw new ApplicationException("The subscription could not be reinitialized.", ex);
			}
			finally
			{
				conn.Disconnect();
			}
' Define server, publication, and database names.
Dim subscriberName As String = subscriberInstance
Dim publisherName As String = publisherInstance
Dim publicationName As String = "AdvWorksProductTran"
Dim publicationDbName As String = "AdventureWorks2012"
Dim subscriptionDbName As String = "AdventureWorks2012Replica"

' Create a connection to the Subscriber.
Dim conn As ServerConnection = New ServerConnection(subscriberName)

Dim subscription As TransPullSubscription

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

    ' Define subscription properties.
    subscription = New TransPullSubscription()
    subscription.ConnectionContext = conn
    subscription.DatabaseName = subscriptionDbName
    subscription.PublisherName = publisherName
    subscription.PublicationDBName = publicationDbName
    subscription.PublicationName = publicationName

    ' If the pull subscription and the job exists, mark the subscription
    ' for reinitialization and start the agent job.
    If subscription.LoadProperties() And (Not subscription.AgentJobId Is Nothing) Then
        subscription.Reinitialize()
        subscription.SynchronizeWithJob()
    Else
        ' Do something here if the subscription does not exist.
        Throw New ApplicationException(String.Format( _
         "A subscription to '{0}' does not exists on {1}", _
         publicationName, subscriberName))
    End If
Catch ex As Exception
    ' Do appropriate error handling here.
    Throw New ApplicationException("The subscription could not be reinitialized.", ex)
Finally
    conn.Disconnect()
End Try

커뮤니티 추가 항목

추가
표시: