Storing migration information of a database - 6.3

Talend MDM Platform Studio User Guide

EnrichVersion
6.3
EnrichProdName
Talend MDM Platform
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

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:

  1. Follow the steps outlined in Migrating the distant database.

  2. In the DQ Repository tree view, expand Metadata > DB Connections.

  3. 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:

    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.