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

SQL Anywhere 12.0.0 » SQL Remote » Managing SQL Remote systems » Resynchronizing subscriptions

 

Synchronize

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.

Caution

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

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

  2. Use the SQL Anywhere 12 plug-in to 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.