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.

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.