Upgrade to release 9.5

About this task

To migrate the database from Release 9.0 (or later) to Release 9.5, run the upgrade script. The SQL script is executed with a database client. The supported database vendors are DB2® and Oracle.

Note: The database used for upgrade must be the same one used for the previous version installation. For example, when you upgrade from Release 9.4 to Release 9.5, the database used for upgrade must be the same one used for the Release 9.4 installation.

Procedure

When migrating from 9.1 to 9.2, run the following command:
- For DB2, run /WEB-INF/sql/DB2/migration/DEBS_9_1_to_DEBS_9_2/db2_upgrade.sql.
- For Oracle, run /WEB-INF/sql/Oracle/migration/DEBS_9_1_to_DEBS_9_2/oracle_upgrade.sql.
When migrating from 9.2 to 9.2.1, run the following command:
- For DB2, run /WEB-INF/sql/DB2/migration/DEBS_9_2_to_DEBS_9_2_1/db2_upgrade.sql.
- For Oracle, run /WEB-INF/sql/Oracle/migration/DEBS_9_2_to_DEBS_9_2_1/oracle_upgrade.sql.
Note: From release 9.2.1 onwards there are no database changes. Therefore, you need not run the upgrade script when migrating from 9.2.1 to 9.3, or 9.3 to 9.4, or 9.4 to 9.5.