Contents Index Rebuild tools Exporting table data or table schema

ASA SQL User's Guide
  Importing and Exporting Data
    Rebuilding databases

Rebuild file formats


From one ASA database to another 

Rebuilding generally takes data out of an Adaptive Server Anywhere database and then places that data back into an Adaptive Server Anywhere database. The unloading and reloading are closely tied together since you usually perform both tasks, rather than just one or the other.

Rebuilding a database 

You might rebuild your database if you wanted to:

Upgrading a database 

New versions of the Adaptive Server Anywhere database server can be used without upgrading your database. If you want to use features of the new version that require access to new system tables or database options, you must use the upgrade utility to upgrade your database. The upgrade utility does not unload or reload any data.

If you want to use features of the new version that rely on changes in the database file format, you must unload and reload your database. You should back up your database after rebuilding the database.

To upgrade your database file, use the new version of Adaptive Server Anywhere.

For more information about upgrading your database, see Upgrading Adaptive Server Anywhere.


Contents Index Rebuild tools Exporting table data or table schema