User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To synchronize a subscription for a user to a publication.

Syntax

     SYNCHRONIZE SUBSCRIPTION TO publication-name [ ( string ) ]
          ...     FOR userid,...

Usage

Anywhere. This statement is applicable only to SQL Remote.

Permissions

Must have DBA authority.

Side effects

Automatic commit.

See also

• CREATE SUBSCRIPTION statement
• START SUBSCRIPTION statement
• "Synchronizing databases",

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