About this task
Every time you migrate the report database, detailed information about the migration done on the report database is stored in the tdq_migration table in the datamart.
To access the migration table in a specific database connection, do the following:
- Follow the steps outlined in Migrating the distant database.
- In the DQ Repository tree view, expand Metadata > DB Connections.
In the relevant database connection, expand the report database and then in
the Tables folder, right-click the
tdq_migration table and then 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:
Incremented ID for each migration.
Migration task name.
Previous version of the database.
Updated version of the database.
Migration date and time.