Manually moving repository items from an XML database to a relational database - 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

Prerequisite(s): You can carry out this operation with both MDM servers up and running provided you have a connection to each of them in the Server Explorer panel in Talend Studio, or you can perform the export operation from the server with the XML database, stop this server, start up the server with the relational database and complete the import operation.

Warning

If you need to migrate between two databases on a single machine, you must run the two MDM servers side by side. You can do this by setting a different port binding on the target server.

For further information about running multiple instances of Tomcat on the same machine, see Talend Installation Guide.

To manually move your repository items from an existing XML database to a relational database, do following:

  1. In the MDM Repository tree view of Talend Studio that is connected to the server with the XML database, click the Export Items button in the repository icon bar.

  2. In the [Export Repository items] window that opens, specify the location to which you want to export your repository items, select the items you want to export, and then click Finish.

  3. In the MDM Repository tree view of Talend Studio that is connected to the server with the relational database, click the Import Items button in the repository icon bar.

  4. In the [Import Repository items] window that opens, specify the location where the repository items you want to import are stored, select the items you want to import, and then click Finish.