When you migrate the report database, detailed information about this operations is stored in the tdq_migration table in the datamart.
Before you begin
- In the DQ Repository tree view, expand .
In the relevant database connection, expand the report database and then in the
Tables folder, right-click the
tdq_migration table and select Preview
Table from the contextual menu.
The SQL Editor is displayed showing all migration information held in the migration table.The table below describes the information presented in the migration table:
Column name Description ID Incremented ID for each migration. MIGRATION_NAME Migration task name. PREVIOUS_VERSION Previous version of the database. UPDATE_VERSION Updated version of the database. MIGRATION_DATE Migration date and time.