Remote database extraction

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.

  • 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.

    One method to increase efficiency is to create more than one remote database.

 See also

Extracting remote databases automatically