User's Guide

Part VI. SQL Anywhere Reference

Chapter 39. SQL Anywhere Components

Databases can be unloaded and rebuilt using one of two rebuild components: using the Rebuild wizard in Sybase Central or the Rebuild batch or command file, which invokes a series of SQL Anywhere utilities to rebuild a database.

Rebuilding a database using the Rebuild wizard in Sybase Central

Sybase Central's Rebuild wizard provides a chance for changing database configuration while rebuilding a database. The configuration settings that can be changed include page size and some database attributes (encryption, tailing blanks, and case sensitivity).

To rebuild a database:

1. Open the Database Utilities folder in the left panel.
2. Double-click Rebuild Database in the right panel. The Rebuild Wizard is displayed.
3. Follow the instructions in the Wizard.

Rebuilding a database using the REBUILD batch or command file

Syntax

     rebuild old-database new-database [dba-password]

See also

DBINIT, DBUNLOAD, ISQL

Description

This DOS or Windows NT batch file, OS/2 command file, or QNX script uses DBUNLOAD to rebuild old-database into new-database. This is a simple script, but it helps document and automate the rebuilding process. Both database names should be specified without extensions. An extension of DB. will automatically be added.

The dba-password must be specified if the password to the DBA user ID in the old-database is not the initial password SQL.

REBUILD runs the DBUNLOAD, DBINIT, and ISQL commands with the default command line options. If you need different options, you will need to run the three steps separately.