Remote database extraction to a reload file

For information about automatically extracting remote databases, see Remote database extraction.

In most deployment scenarios, you need to customize the extraction and creation of remote databases. You can create a custom extraction by choosing to extract the database into a script file and a series of text files. Then, you can edit these files as required.

When you extract the database into files, you decide whether to create:

A SQL script file named reload.sql that contains the statements necessary to build the remote database schema See -n option Extraction utility (dbxtract).

For example, run the following command:

dbxtract -c "UID=DBA;PWD=sql;DBF=c:\cons\cons.db" -n "c:\remote\reload.sql" UserName

A series of data files, each of which contains the contents of a database table A series of data files, each of which contains the contents of a database table. A new directory is created, named extract, to contain the data files. You can use these files to load data into an existing remote database. See -d option Extraction utility (dbxtract).

For example, run the following command:

dbxtract -c "UID=DBA;PWD=sql;DBF=c:\cons\cons.db" -d "c:\remote1" UserName

Both the reload.sql file and the data files A new directory is created, named extract, to contain the data files. The reload.sql file contains instructions to load the data files. For example, run the following command:

dbxtract -c "UID=DBA;PWD=sql;DBF=c:\cons\cons.db" "c:\remote1\reload.sql" UserName

The reload.sql file

The reload.sql file contains the SQL statements necessary to build the database schema, including statements to create:

Publishers, remote, and consolidated users
Publications and subscriptions
Message types
Tables
Views
Triggers
Procedures

Note

You may need to edit reload.sql when you create remote databases. The Extraction utility (dbxtract) is intended to assist in preparing remote databases, but is not intended as a black box solution for all circumstances.

Create a remote database from the reload.sql file (command line)

Use the Extraction utility (dbxtract) to extract the database schema and data to files. For example, run the following command:

dbxtract -c "UID=DBA;PWD=sql;DBF=c:\cons\cons.db" "c:\remote\reload.sql" UserName

By default, subscriptions for the specified remote user are started automatically.

Edit the reload.sql, if required.
Create an empty SQL Anywhere database.

For example, run the following command:
dbinit c:\rem1\rem1.db
Connect to the database from Interactive SQL, and run the reload.sql script file.

For example, run the following command:
READ remote\reload.sql
The new remote database, rem1.db, is created with the appropriate schema, remote users, publications, subscriptions, and triggers. However, the Extraction utility (dbxtract) does not start the SQL Remote Message Agent, so no messages are exchanged.