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

SQL Anywhere 11.0.1 » SQL Remote » SQL Remote Deployment and Administration » SQL Remote Administration » Resynchronizing subscriptions



It is recommended that you 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 Message Agent (dbremote) when running the Extraction utility (dbxtract) or the Extract Database Wizard.

To synchronize a subscription (Sybase Central)
  1. Shut down the Message Agent on the remote database and the consolidated database.

  2. Connect to the consolidated database as a user with DBA authority.

  3. In the left pane, expand the Publications directory.

  4. Select a publication.

  5. In the right pane, click the SQL Remote Subscriptions tab.

  6. Manually synchronize subscriptions:

    1. Right-click the user in the Subscribers list and choose 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.