To upgrade a user database or transaction log dump to the current version of Adaptive Server:
Use load database and load transaction to load the dump to be upgraded.
Adaptive Server determines from the dump header which version it is loading. After the dump header is read, and before Backup Server begins the load, the database is marked offline by load database or load transaction. This makes the database unavailable for general use (queries and use database are not permitted), provides the user greater control over load sequences, and eliminates the possibility that other users will accidentally interrupt a load sequence.
Use online database, after the dump has successfully loaded, to activate the upgrade process.
Do not issue online database until
after all transaction dumps are loaded.
Prior to SQL Server version 11.0, a database was automatically available at the end of a successful load sequence. With the current version of Adaptive Server, the user is required to bring the database online after a successful load sequence, using online database.
For dumps loaded from versions 11.9, 12.0, and 12.5, online database activates the upgrade process to upgrade the dumps just loaded. After the upgrade is successfully completed, Adaptive Server places the database online, and the database is ready for use.
For dumps loaded from the current version of Adaptive Server, no upgrade process is activated. You must still issue online database to place the database online—load database marks it as offline.)
Each upgrade step produces a message stating what it is about to do.
An upgrade failure leaves the database offline and produces a message stating that the upgrade failed and the user must correct the failure.
For more information about online database, see the Reference Manual.
After successful execution of online database, use dump database. The database must be dumped before a dump transaction is permitted. A dump transaction on a newly created or upgraded database is not permitted until a successful dump database has occurred.
