Typically, the system specialist upgrades a database after installing a new Metrics Management service pack or a new version of Metrics Management. If Upgrade Database is unavailable in the Navigation Pane, the database does not require an upgrade.
At the beginning of the upgrade, Metrics Management creates a backup of a Standard database. If the upgrade fails, Metrics Management restores the database from the backup. Metrics Management does not create a backup of SQL Server and Oracle databases. Ensure that the database administrator creates a backup of a SQL Server or Oracle database before upgrading.
How to upgrade a database
1 In Servers and Databases, select the database to upgrade.
2 In the Navigation Pane, choose Database Tools➛Upgrade Database.
3 Choose Upgrade Database. In the confirmation message, choose OK. Metrics Management displays the progress of the upgrade, as shown in Figure 10‑42.
Figure 10‑42 The progress of a database upgrade
4 After the process is complete, a message indicates that the database upgraded successfully. Choose OK.
