Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 17. Command Reference for Adaptive Server Anywhere       

SYNCHRONIZE SUBSCRIPTION statement

Function 

To synchronize a subscription for a user to a publication.

Syntax 

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

Parameters 

Parameter	Description
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.

Permissions 

Must have DBA authority.

Side effects 

Automatic commit.

See also 

CREATE SUBSCRIPTION statement

START SUBSCRIPTION statement

Description 

A SQL Remote subscription is said to be 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. It is recommended that where possible you use the database extraction utility instead to synchronize subscriptions without using a message system.

Example 

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

SYNCHRONIZE SUBSCRIPTION TO pub_contact
FOR SamS