迁移 Talend MDM Server 的数据库

Talend Open Studio for MDM 安装和升级指南,适用于: Windows

Language
中文(简体)
EnrichDitaval
open-studio-for-mdm-windows
Content
数据治理

步骤

  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