What is required to upgrade to the latest version of the History Database (HDB)?
There appears to be no specific documentation about this, with only brief mentions about the apparent schema changes in the HDB database (DB).
Where/How can the HDB be upgraded?
As per the Release Notes for version 9.0:
The One Identity Manager History Database has been significantly simplified in order to reduce the effort required to, on the one hand, set up and operate the database and, on the other hand, to enable it to operate on Azure SQL Databases. The History Database represents only a simple data storage. The History Database does not include the One Identity Manager modules or system configuration data. There are no longer any active components.
Declare the One Identity Manager History Database to be used for transferring data to the One Identity Manager in the TimeTrace.
- It is recommended to install the History Database first!
- Existing databases are still supported for querying archived data in TimeTrace and reports. These databases do not need to be migrated.
- If you still want to migrate an existing History Database, ensure that the all functions, procedures, tables, and views that are not in the following list are deleted by the History Database migration:
HistoryChain, HistoryJob, ProcessChain, ProcessGroup, ProcessInfo, ProcessStep, ProcessSubstitute, RawJobHistory, RawProcess, RawProcessChain, RawProcessGroup, RawProcessStep, RawProcessSubstitute, RawWatchOperation, RawWatchProperty, SourceColumn, SourceDatabase, SourceTable, WatchOperation, WatchProperty
- Save any custom extensions before migrating.
The Data Archiving Admin guide provides the required installation steps:
Installing a One Identity Manager History Database