SQL Remote User's Guide
Deploying and Synchronizing Databases
Using the extraction utility
This section describes how to extract a database for a remote user from the current consolidated database. This section applies only to Adaptive Server Anywhere consolidated databases.
When you complete the Extract Database wizard, it does the following on your machine:
Creates the remote database
Extracts (unloads) the relevant structures and/or data from the consolidated database to files
Loads those files into the newly created remote database
To extract a database for a remote user (Sybase Central)
In the left pane, select the Adaptive Server Anywhere 9 plug-in.
In the right pane, click the Utilities tab.
In the right pane, double-click Extract Database.
Follow the instructions in the wizard.
You can also access this wizard by clicking Tools
If you use the wizard to extract a non-running database, it is only able to unload the structure and data for you. It cannot create the remote database and reload it. For this reason, we recommend that you always extract from a consolidated database that you are connected to in Sybase Central.
You can also invoke the extraction wizard for a particular database or for a particular remote user—Sybase Central automatically fills in the appropriate entries in the wizard.
The extraction wizard always extracts (synchronizes) the remote database using the WITH SYNCHRONIZATION option. In those rare cases where you don't want to use this option, you must use the dbxtract utility instead.
For information about the extraction utility options, available as command-line options or as choices presented by the extraction wizard, see Extraction utility options.