Converting a Database from a Previous Version to Version 7.4 and vice versa

This section describes how to convert an existing database from one version to another.

Procedural Steps

The following procedural steps are highly recommended when converting a database:

  1. Create a backup of your existing database. Use the old version of ADABCK to back up the whole database.

  2. Modify the security configuration files.

  3. Convert the version of the database by performing the steps described below.

  4. Validate the consistency of the database. Use the FIELD and INDEX functions of the ADAVFY utility to validate the consistency of the database.


Upgrading Databases from Versions 7.2 and 7.3 to Version 7.4

Upgrading a Database in Place

A database running a version prior to version 7.4 can be upgraded in two ways. The easiest and most recommended way is to convert it in place by running the utility ADACVT.

Alternative Method to Upgrade a Database

You can also convert a database from an older version to Version 7.4 using the utility ADABCK. This is done by restoring a backup made with ADABCK of the older version and restoring it with ADABCK Version 7.4. ADABCK will make the necessary changes during the restore operation.

Note
Because the internal structure of the database has changed, you must first delete the database container files in the target environment, then you can restore the database.

Upgrading Databases with Role-Based Access Control (RBAC) enabled

After upgrading with ADACVT or ADABCK, you must call the command ADARBA DBID=<dbid> UPGRADE to add permissions for the utilities ADADBM and ADAOPR. Otherwise, these utilities are not able to run.

Downgrading Databases with Version 7.4 to a Previous Version

You can use the utility ADACVT to convert a database to a previous version. ADACVT converts the database in place to the selected target version. A downgrade is not possible if features introduced with a more recent version than the target version were used. Downgrading an encrypted database can only be done if the target version supports the used key management system.