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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Data import and export » Database rebuilds

 

Reloading a database

You can reload databases from the command line. Reloading involves creating an empty database file and using the reload.sql file to create the schema and insert all the data unloaded from another SQL Anywhere database into the newly created tables.

Prerequisites

You must have the reload.sql file.

 Task
  1. Run the dbinit utility to create a new empty database file.

  2. Connect to the new database.

  3. Execute the reload.sql script.

Results

The database is reloaded.

Example

The following command creates a file named mynewdemo.db.

dbinit -dba DBA,sql mynewdemo.db

The following command loads and runs the reload.sql script in the current directory.

dbisql -c "DBF=mynewdemo;UID=DBA;PWD=sql" reload.sql

 See also