Extracting a remote database in Sybase Central

Running the extraction utility from Sybase Central carries out the following tasks related to creating and synchronizing SQL Remote subscriptions:

  • Creates a command file to build a remote database containing a copy of the data in a specified publication.
  • Creates the necessary SQL Remote objects, such as message types, publisher and remote user IDs, publication and subscription, for the remote database to receive messages from and send messages to the consolidated database.
  • Starts the subscription at both the consolidated and remote databases.
Note

Only tables for users selected in the Configure Owner Filter window appear in the Extract Database Wizard. If you want to view tables belonging to a particular database user, right-click the database you are unloading, choose Configure Owner Filter from the popup menu, and then select the desired user in the resulting window.

To extract a remote database from a running database (Sybase Central)

  1. Connect to the database.

  2. From the Tools menu, choose SQL Anywhere 11 » Extract Database.

    The Extract Database Wizard appears.

  3. Follow the instructions in the wizard.

Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0