迁移 Talend MDM Server 的数据库 - 7.3

Talend 迁移与升级指南

Version
7.3
Language
中文(简体)
Product
Talend Big Data
Talend Big Data Platform
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 Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend Data Preparation
Talend Data Stewardship
Talend ESB
Talend Identity and Access Management
Talend JobServer
Talend Log Server
Talend MDM Server
Talend MDM Web UI
Talend Runtime
Talend SAP RFC Server
Talend Studio
Content
安装和升级
Last publication date
2023-05-23
适用产品...

Data Fabric

MDM Platform

步骤

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