User's Manual

Chapter 9. Deploying and Synchronizing Databases
Using the extraction utility
The extraction utility is an aid to creating remote Adaptive Server Anywhere
databases. It cannot be used to create remote Adaptive Server Enterprise
databases.
Running the extraction
utility
The extraction utility can be accessed in the following ways:
♦ From Sybase Central, if your consolidated database is Adaptive Server
Anywhere.
♦ As a command-line utility. This is the dbxtract utility (Adaptive Server
Anywhere), or the ssxtract utility (Adaptive Server Enterprise).
Caution
Do not run the Message Agent while running the extraction utility. The
results are unpredictable.
Creating a database from the reload files
The command-line utility unloads a database schema and data suitable for
building a remote Adaptive Server Anywhere database for a named
subscriber. It produces a SQL command file with default name reload.sql
and a set of data files. You can use these files to create a remote Adaptive
Server Anywhere database.
Editing of reload.sql may be needed
The database extraction utility is intended to assist in preparing remote
databases, but is not intended as a black box solution for all circumstances.
You should edit the reload.sql command file as needed when creating
remote databases.
❖ To create a remote database from the reload file
1. Create an Adaptive Server Anywhere database using one of the following:
♦ the Sybase Central Create Database wizard (from the Tools menu,
choose Adaptive Server Anywhere 9 ➤ Create Database)
♦ the dbinit utility
2. Connect to the database from the Interactive SQL utility, and run the
reload.sql command file. The following statement entered in the SQL
Statements pane runs the reload.sql command file:
read path\reload.sql
where path is the path of the reload command file.
191