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

SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Importing and exporting data » Rebuilding databases


Reload a database

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. You reload databases from the command line.

 ♦  To reload a database (command line)
  1. Run the dbinit utility to create a new empty database file.

    For example, the following command creates a file named mynewdemo.db.

    dbinit mynewdemo.db
  2. Execute the reload.sql script.

    For example, the following command loads and runs the reload.sql script in the current directory.

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