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

SQL Anywhere 11.0.0 » SQL Remote » SQL Remote Administration » Deploying and synchronizing databases with SQL Remote » Using the Extraction utility (dbxtract)

 

Using the Extraction utility from Sybase Central

This section describes how to extract a database for a remote user from the current consolidated database. This section applies only to SQL 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)

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

  2. Follow the instructions in the wizard.

Notes
  • You can also access this wizard by choosing Tools » SQL Anywhere 11 » Extract Database.
  • You can also invoke the Extract Database Wizard for a particular database or for a particular remote user—Sybase Central automatically fills in the appropriate entries in the wizard.
  • The Extract Database 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.
  • 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, and then select the desired user in the resulting window.
See also