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 data mart.

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 migration table displays the following information:

   • ID: the incremented ID for each migration.
   • MIGRATION_NAME: the migration task name.
   • PREVIOUS_VERSION: the previous version of the database.
   • UPDATE_VERSION: the updated version of the database.
   • MIGRATION_DATE: the migration date and time.