迁移 Talend MDM Server 的数据库 - 7.1

Talend Open Studio for MDM 安装与升级指南 (Windows)

EnrichVersion
7.1
EnrichProdName
Talend Open Studio for MDM
task
数据治理
EnrichPlatform
Talend MDM Server
Talend MDM Web UI
Talend Studio

过程

  1. 停止 Talend MDM Server. 有关更多信息,请参阅速查表:Talend 服务器模块的启动和停止命令
  2. 移除相关数据库外键。外键名称可能随 Talend MDM Server 版本而异。
    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. 重新启动 Talend MDM Server