Storing migration information of a database - Cloud - 8.0

Talend Studio User Guide

Version
Cloud
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-29
Available in...

Big Data Platform

Cloud API Services Platform

Cloud Big Data Platform

Cloud Data Fabric

Cloud Data Management Platform

Data Fabric

Data Management Platform

Data Services Platform

MDM Platform

Real-Time Big Data Platform

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

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.
    Contextual menu of a table from a database connection.

    The SQL Editor is displayed showing all migration information held in the migration table.

    Overview of the migration information in the SQL Editor.
    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.