Introduction
New customers install DirX Audit according to the DirX Audit Installation Guide and work with the product. Existing customers must migrate their environment.
Migration from DirX Audit 7.1, 7.1 SP1, and 7.1 SP2
Migration from DirX Audit 7.1, 7.1 SP1, and 7.1 SP2 requires you to perform preparation steps and an upgrade installation including the initial configuration and then perform the migration steps described in the next chapters.
The migration procedure consists of the audit messages database (Data DB) update and the history entries database (History DB) update. There are no modifications to the configuration database (Config DB).
Features to be Migrated
This section provides an overview of the features to be migrated and explains the underlying concepts.
Issues Relevant for Upgrade from 7.1 to 7.1 SP1
This section comprises all issues relevant for version 7.1 only.
Audit Messages Database Update
New indexes have been added to the DAT_AUDITMESSAGES and DAT_AUDITEVENTS tables for the SQL Server. No change for Oracle Database.
Issues Relevant for Upgrade from 7.1 SP1 to 7.1 SP2
This section comprises all issues relevant for version 7.1 SP1 only.
History Entries Database Update
The DIM_HST_GEN_DATETIME view has been replaced with a table to improve performance.
A new HDB_APPROVALS table has been added to provide data on approvals realized in DirX Identity.
The FCT_HST_CERTCAMPAIGNS_LIFECYCLE and HDB_CERTCAMPAIGNS_LIFECYCLE tables have been removed. All certification campaign data are provided with FCT_HST_CERTCAMPAIGNS and HDB_CERTCAMPAIGNS tables.
The FCT_HST_IMPORTED_MEMBERSHIPS table has been modified to improve performance.
Other minor improvements and fixes were also made.
Issues Relevant for Upgrade from 7.1 SP2 to 7.2
This section comprises all issues relevant for version 7.1 SP2 only.
Audit Messages Database Update
The database behavior when DAT_AUDITEVENTS records are deleted has been modified for both SQL Server and Oracle Database.
History Entries Database Update
Since DirX Audit 7.2, user-to-privilege assignments are synchronized the same way as other entry types. Consequently, the HST_ASSIGNMENTS_IN_TIME table has been removed from the database schema and all its original data will be migrated during the manual migration process. In addition, the HST_ROLEPARAMS_IN_TIME table has been modified to reflect these changes.
The FCT_HST_IMPORTED_MEMBERSHIPS view has been replaced with the table of the same name to improve performance.
The FCT_RSK_COMPOUND_USERS view and RSK_COMPOUND_STATISTICS, RSK_COMPOUND_SCORES, RSK_STATISTICS, RSK_SCORES, RSK_COMPOUND_FACTOR_WEIGHTS, RSK_COMPOUND_FACTORS, RSK_FACTORS, and RSK_LEVELS tables have been removed as DirX Audit risks have been deprecated and only DirX Identity risk data is available.
The HST_ENTRIES table has been modified, the DIRX_ENTRY_UUID column is considered mandatory and unique.
The HST_LDAP_ATTRS table has been extended with a new column TYPE_NAME.
A new HDB_ASSIGNMENTS view has been added to provide data on assignments.
The HDB_ENTRY_OBJECTS view has been removed.
The HDB_ENTRY_ATTRIBUTES, HDB_USER_ROLES, HDB_USER_PERMISSIONS, HDB_USER_GROUPS, HDB_USER_ACCOUNTS, HDB_ROLE_ROLES, HDB_ROLE_PERMISSIONS, and HDB_PERMISSION_GROUPS views have been modified to improve performance.
The HDB_USER_PRIVILEGES view has been added.
Other minor improvements and fixes were also made.