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.
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|