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:
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.
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.
The steps for a complete migration between two relational databases are similar to those from an XML database to a relational database.