User's Manual

Chapter 14. Utilities and Options Reference
Option Description
–xv Exclude views
–xx External unload, external load
–y Overwrite command file without confirmation
directory The directory to which the files are written. This is
not needed if you use -an or -ac
subscriber The subscriber for whom the database is to be
extracted.
Description ssxtract is the extraction utility for Adaptive Server Enterprise. It is run
against a Adaptive Server Enterprise and creates a command file for a
remote Adaptive Server Anywhere database.
dbxtract is the extraction utility for Adaptive Server Anywhere. It is run
against an Adaptive Server Anywhere database and creates a command file
for a remote Adaptive Server Anywhere database.
There is no extraction utility to create remote Adaptive Server Enterprise
databases.
The extraction utility creates a command file and a set of associated data
files. The command file can be run against a newly-initialized Adaptive
Server Anywhere database to create the database objects and load the data
for the remote database.
By default, the command file is named reload.sql .
If the remote user is a group, then all the user IDs that are members of that
group are extracted. This allows multiple users on a remote database with
different user IDs, without requiring a custom extraction process.
SSXtract notes
Deprecated feature
In the next major release of SQL Anywhere Studio, SQL Remote for
Adaptive Server Enterprise will not be present. MobiLink provides a more
flexible and scalable solution for data synchronization between Adaptive
Server Enterprise and Adaptive Server Anywhere databases.
Not all Adaptive Server Enterprise objects have corresponding objects in
Adaptive Server Anywhere. The ssxtract utility has the following
limitations:
♦ Single database All extracted objects must be in a single Adaptive
305