Creating a database from the reload files

SQL Remote User's Guide
Deploying and Synchronizing Databases
Using the extraction utility

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

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

When used from Sybase Central, the extraction utility carries out the database unloading task, in the same way that dbxtract does, and then takes the additional step of creating the new database.

The extraction utility does not use a message system. The reload file (ssxtract/dbxtract) or database (from Sybase Central) is created in a directory accessible from the current machine. Synchronizing many subscriptions over a message link can produce heavy message traffic and, if the message system is not completely reliable, it may take some time for all the messages to be properly received at the remote sites.