SQL Remote User's Guide
  Utilities and Options Reference
    The Database Extraction utility

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.

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

1. Connect to the database.

2. Right-click the database and choose Extract Database from the popup menu.

3. Follow the instructions in the wizard.

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

1. In the left pane, select the Adaptive Server Anywhere 9 plug-in.

2. In the right pane, click the Utilities tab.

3. In the right pane, double-click Extract Database.

4. Follow the instructions in the wizard.