Storing migration information of a database

When you migrate the report database, detailed information about this operations is stored in the tdq_migration table in the datamart.

1. In the DQ Repository tree view, expand Metadata > DB Connections.
2. 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.