The command line utility unloads a database schema and data suitable for building a remote SQL 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 SQL 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.
Create a SQL Anywhere database using one of the following:
the Sybase Central Create Database wizard (from the Tools menu, choose SQL Anywhere 10 > Create Database)
the dbinit utility
Connect to the database from Interactive SQL, and run the reload.sql command file. The following statement entered in the SQL Statements pane runs the reload.sql command file:
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 (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.