Upgrading a user database

You can load dumps into the current version of Adaptive Server from any version of Adaptive Server that is at version 11.9 and later. The loaded database is not upgraded until you issue online database.

The steps for upgrading user databases are the same as for system databases:

  1. Use load database to load a database dump of a version 11.9 or later Adaptive Server. load database sets the database status to “offline.”

  2. Use load transaction to load, in order, all transaction logs generated after the last database dump. Load all transaction logs before going to step 3.

  3. Use online database to upgrade the database. The online database command upgrades the database because its present state is incompatible with the current version of Adaptive Server. When the upgrade completes, the database status is set to “online,” which makes the database available for public use.

  4. Make a dump of the upgraded database. A dump database must occur before a dump transaction command is permitted.

See the Reference Manual: Commands.