Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Remote » Managing SQL Remote systems » Subscription resynchronization


Synchronizing subscriptions

Manually synchronize publications for subscribed users.


You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Context and remarks

Use either the Extraction utility (dbxtract) or the Extract Database Wizard to extract the data for the specified remote database and then manually load the data into the remote database.


Do not run the SQL Remote Message Agent (dbremote) when running the Extraction utility (dbxtract) or the Extract Database Wizard.

  1. Shut down the SQL Remote Message Agent on the remote database and the consolidated database.

  2. Connect to the consolidated database.

  3. Double-click Publications.

  4. Double-click a publication.

  5. Click the SQL Remote Subscriptions tab.

  6. Manually synchronize subscriptions:

    1. Right-click the user in the Subscribers list and click Properties.

    2. Click the Advanced tab.

    3. Click Synchronize Now.

      The subscriptions are affected when you click the Synchronize Now button. Subsequently clicking Cancel on the properties window does not cancel the synchronize action.

  7. Click OK.


The subscriptions are synchronized.

 See also