User's Manual

Server Enterprise database.
♦ Passwords The password for the extracted user IDs are the same as the
user ID itself.
♦ Permissions The extracted user ID is granted REMOTE DBA
authority.
♦ Named constraints These are extracted as Adaptive Server Anywhere
CHECK constraints.
♦ System tables The sp_populate_sql_anywhere SQL Remote
procedure builds a set of Adaptive Server Anywhere system tables in
TEMPDB from the Adaptive Server Enterprise system tables. The
extracted schema comes from these temporary system tables.
☞ For more information about the Extraction utility options, see
“Extraction utility options” on page 306.
Extraction utility options
Write file utility options (@data) Use this option to read in options from
the specified environment variable or configuration file. If both exist with the
same name, the environment variable is used.
☞ For more information about configuration files, see “Using configuration
files” [ASA Database Administration Guide, page 495].
If you want to protect passwords or other information in the configuration
file, you can use the File Hiding utility to obfuscate the contents of the
configuration file.
☞ For more information, see “Hiding the contents of files using the
dbfhide command-line utility” [ASA Database Administration Guide, page 524].
Create a database for reloading (–an) You can combine the operations of
unloading a database, creating a new database, and loading the data using
this option.
For example, the following command (which should be entered all on one
line) creates a new database file named asacopy.db and copies the schema
and data for the field_user subscriber of asademo.db into it:
dbxtract -c "uid=dba;pwd=sql;dbf=asademo.db"
-an asacopy.db field_user
If you use this option, no copy of the data is created on disk, so you do not
specify an unload directory in the command. This provides greater security
for your data, but at some cost for performance.
306