Migrating MDM instances - 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

You can also migrate MDM instances directly from an XML database to a relational database or between two relational databases using the dbmigration tool.

Prerequisites: If you want to migrate from 5.6.1 or 5.6.2 to 6.0.1 or later, you have to install a patch. To obtain this patch, contact Talend support.

Since not everything is stored in a database, you must also manually import and redeploy the following items:

  • Jobs,

  • workflows

  • pictures,

  • web resources.

Note that Talend MDM data models only support certain types, as shown in the following table. When you migrate a project containing unsupported types, errors will occur.

Supported types

Unsupported types

xsd:anyURI

xsd:ENTITIES

xsd:base64Binaryxsd:gDay
xsd:booleanxsd:gMonth
xsd:byte xsd:gMonthDay
xsd:datexsd:gYear
xsd:dateTime xsd:gYearMonth
xsd:decimalxsd:ID
xsd:doublexsd:IDREF
xsd:durationxsd:IDREFS
xsd:floatxsd:language
xsd:hexBinaryxsd:Name
xsd:intxsd:NMTOKEN
xsd:integerxsd:normalizedString
xsd:languagexsd:QName
xsd:longxsd:token
xsd:negativeInteger-
xsd:nonNegativeInteger-
xsd:nonPositiveInteger-
xsd:normalizedString-
xsd:positiveInteger-
xsd:short-
xsd:string-
xsd:time-
xsd:token-
xsd:unsignedByte-
xsd:unsignedInt-
xsd:unsignedLong-
xsd:unsignedShort-

Warning

You must delete your web browser cache and cookies whenever you change the version, or the Studio. Unpredictable behavior or display errors will occur if you do not.

The following sections explain all the tasks you must carry out to perform a complete migration of all the system objects and all the data objects you have on the MDM server from an XML database to a relational database, including master-records, Jobs, workflows, pictures and web resources.

Note

The steps for a complete migration between two relational databases are similar to those from an XML database to a relational database.