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.
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 a SQL Anywhere database using one of the following:
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 computer. 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.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|