SYNCHRONIZE SUBSCRIPTION statement [SQL Remote]

Synchronizes a subscription for a user to a publication.

Syntax

SYNCHRONIZE SUBSCRIPTION
TO publication-name [ ( subscription-value ) ]
FOR remote-user, ...

Parameters

publication-name
The name of the publication to which the user is being subscribed. This may include the owner of the publication.
subscription-value
A string that is compared to the subscription expression of the publication. The value is required here because each subscriber may have more than one subscription to a publication.
remote-user
The user ID of the subscriber to the publication. This user must have a subscription to the publication.

Remarks

A SQL Remote subscription is synchronized when the data in the remote database is consistent with that in the consolidated database, so that publication updates sent from the consolidated database to the remote database will not result in conflicts and errors.

To synchronize a subscription, a copy of the data in the publication at the consolidated database is sent to the remote database. The SYNCHRONIZE SUBSCRIPTION statement does this through the message system. Where possible, you use the database extraction utility (dbxtract) instead to synchronize subscriptions without using a message system.

Privileges

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

The following statement synchronizes the subscription of user Sam_Singer to the pub_contact publication.

SYNCHRONIZE SUBSCRIPTION
   TO pub_contact
   FOR Sam_Singer;