Extracting remote databases

To create a database for a remote user, you extract the remote database from the consolidated database.

You can use either the Extract Database Wizard or the Extraction utility (dbxtract) to extract a remote database from a consolidated database for a specified remote user. Either method allows you to do one or more of the following tasks:

  • Automatically extract and reload the schema and data directly into a new or existing database   This is an appropriate method to use when learning about SQL Remote. If you use this method, no interim copy of the data is created on disk. This method provides greater security for your data. However, it is more time consuming to implement. See Automatically extract remote databases.

  • Extract the schema and data to files, and then load them into a new or existing database   When deploying SQL Remote, this method is preferred. You can edit the schema file to customize the extraction and creation of your remote databases. See Extracting remote databases to a reload file.

    To increase efficiency when creating more than one remote database, see Creating multiple remote databases.


Automatically extract remote databases