Migrating the database for the MDM server or the Talend Data Stewardship Console server - 6.1

Talend MDM Platform Migration Guide

EnrichVersion
6.1
EnrichProdName
Talend MDM Platform
task
Installation and Upgrade
EnrichPlatform
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend DQ Portal
Talend ESB
Talend Identity Management
Talend Installer
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Project Audit
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

If the MDM server or the Talend Data Stewardship Console server (for standalone installation) is connected to a database created in a previous version of the MDM server or DSC server, you need to migrate the database as follows:

  1. Stop the MDM server or the DSC server. For more information, see the section Installing the MDM server in Talend Installation Guide.

  2. Remove the related database foreign keys. The foreign key names may vary with the MDM server version.

    MySQL
    alter table srcrecords drop foreign key FK3012B7DEF33FEA26;
    alter table tgtcolumns drop foreign key FKA373D85CF84CB18;
    alter table taskcollayout drop foreign key FK6B328CC5BA76F0CB;
    alter table tasklinelayout drop foreign key FK8707B763BA76F0CB;
    
    MSSQL
    alter table srcrecords drop constraint FK3012B7DEF33FEA26
    alter table tgtcolumns drop constraint FKA373D85CF84CB18
    alter table taskcollayout drop constraint FK6B328CC5BA76F0CB
    alter table tasklinelayout drop constraint FK8707B763BA76F0CB
    
    Oracle, DB2, Postgres
    alter table srcrecords drop constraint FK3012B7DEF33FEA26;
    alter table tgtcolumns drop constraint FKA373D85CF84CB18;
    alter table taskcollayout drop constraint FK6B328CC5BA76F0CB;
    alter table tasklinelayout drop constraint FK8707B763BA76F0CB;
  3. If you are using the MySQL database, update the file <$INSTALLDIR>/conf/dsc-database.properties as follows:

    tdsc.database.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

    INSTALLDIR indicates where the MDM server is installed.

  4. Restart the MDM server or the DSC server.