Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Remote » SQL Remote Administration » Deploying and synchronizing databases with SQL Remote » Using the Extraction utility (dbxtract)

 

Creating a database from the reload files

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.

To create a remote database from the reload file

  1. Create a SQL Anywhere database using one of the following:

    • the Sybase Central Create Database Wizard (from the Tools menu, choose SQL Anywhere 11 » Create Database)
    • the dbinit utility
  2. 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:

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