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

SQL Anywhere 10.0.1 » SQL Anywhere Server - Database Administration » Database Administration Utilities

Ping utility (dbping) Next Page

Rebuild utility (rebuild)


Rebuilds a database file.

Syntax

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

Remarks

This batch file, command file, or shell script uses dbunload to rebuild old-database into new-database. This is a simple script, but it helps document the rebuilding process, and provides a basis for customization. Both database names should be specified without extensions. An extension of .db is automatically added.

You can use dbunload with the -ar option to perform unloading and reloading without using the rebuild batch file.

The DBA-password must be specified if the password for the DBA user in the old-database is not the initial password sql.

It is recommended that the password be composed of 7-bit ASCII characters as other characters may not work correctly if the server cannot convert from the client's character set to UTF-8.

Rebuild runs the dbunload, dbinit, and Interactive SQL commands with the default options. If you need different options, you must run the three commands separately.

You can also rebuild databases as part of the unload process using the Unload Database wizard in Sybase Central. See Using the Unload Database wizard.

Exit codes are 0 (success) or non-zero (failure). See Software component exit codes.

This utility does not accept the @data parameter to read in options from a configuration file.

See also