iAnywhere.com - Extracting a remote database in Sybase Central

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

SQL Anywhere 10.0.1 » SQL Remote » SQL Remote Utilities and Options Reference » 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.

Note

Only tables for users selected in the Filter Objects by Owner dialog 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 Filter Objects by Owner from the popup menu, and then select the desired user in the resulting dialog.

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

Connect to the database.
From the Tools menu, choose SQL Anywhere 10 > Extract Database.

The Extract Database wizard appears.
Follow the instructions in the wizard.