Storing migration information of a database - 7.3

Talend Data Fabric Studio User Guide

Version
7.3
Language
English (United States)
EnrichDitaval
Data Fabric
Product
Talend Data Fabric
Module
Talend Studio
Content
Design and Development

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

Before you begin

You migrated the distant database.

Procedure

  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.