Upgrading the FlexNet Manager for Engineering Applications Reporting Database Schema
Part of the upgrade process includes upgrading the database schema used with FlexNet Manager for Engineering Applications. After installing FlexNet Manager for Engineering Applications Reporting software and before starting it, you must upgrade the database schema to the new version.
The schema upgrade is performed as the database user you supplied through the FlexNet Manager for Engineering Applications Reporting Configurator. The database upgrade script assumes that you are upgrading from an existing version 15.3 or later to version 2020 R1 database.
It is strongly recommended that you back up the database before upgrading the database. The data in the database will be preserved and transformed if necessary.
Important:If you recently upgraded from FlexNet Manager for Engineering Applications 15.3, 15.4, or 15.5 and have not completed the required data-model upgrade and data migration, you must finish this process before upgrading to FlexNet Manager for Engineering Applications 2021 R1. Refer to the version-appropriate Installation Guide for more information.
To upgrade the FlexNet Manager for Engineering Applications Reporting database:
| 1. | Start the database server, if it is not already running. |
| 2. | At the command line, change to the directory reporting_install_directory and ensure the following: |
| • | FlexNet Manager for Engineering Applications Reporting is stopped. |
| • | No database tables are being accessed. |
| 3. | Type flexnet upgradedb. |
This command upgrades the FlexNet database schema, and then migrates existing data and new configuration information to the new schema.
| 4. | Specify whether you want to partition the usage-related tables by typing yes or no. (Before specifying that you want to use database partitioning, verify that the database version your enterprise is using supports partitioning.) |
Note:The database tables for the Reporting server can be partitioned at any time. See the section, {Hyperlink}“Partitioning the Remaining Database Tables (Data Warehouse Tables),”{Default ¹ Font} for information.
| 5. | If you want to use partitioned tables, follow the process outlined in the following section, Partitioning the Remaining Database Tables (Data Warehouse Tables). |
If there are any errors during the upgrade, they are written to the console. A log containing a record of the entire upgrade process is created at: <reporting_install_directory>/logs/upgradedb.log.