Migrating database - 6.1

Talend Big Data Platform Migration Guide

Talend Big Data Platform
Installation and Upgrade
Talend Activity Monitoring Console
Talend Administration Center
Talend Artifact Repository
Talend CommandLine
Talend DQ Portal
Talend Installer
Talend JobServer
Talend Log Server
Talend Project Audit
Talend Repository Manager
Talend Runtime
Talend SAP RFC Server
Talend Studio

The source and target databases must be of the same type. To migrate from a database X to a database Y, for example from H2 to MySQL, first see Talend Installation Guide.

  1. Stop the Tomcat server.

  2. Delete the old Talend Administration Center application .war file in <TomcatPath>/webapps/ to undeploy it.

  3. Delete the <TomcatPath>/work directory to empty Tomcat cache.

  4. Put the new Talend Administration Center application .war file in <TomcatPath>/webapps.

  5. Start Tomcat.

  6. Open a Web browser and type in the application URL. The database configuration page opens and a message indicates that the database version needs to be updated.

  7. Click Proceed migration to start the migration process. A dialog box opens.

  8. In the backup settings area, check your database connection information and enter the path to your folder where the backed up database will be stored in the Dump Path field.

    The command used to migrate the database can be updated according to your needs. If you are migrating an Oracle database from Talend Administration Center 5.6.x to Talend Administration Center 6.x, make sure the -Dtalend.schema=<schemaName> parameter is present in the migration command.

    For more information on the migration commands, see About the migration commands.

  9. Click Proceed to start the database backup and migration operation.

  10. When the message Database migration completed successfully shows, click Finish. The database is migrated and a .zip file holding the backed up database is created in the folder you have defined previously.

  11. On the database configuration page, set your new license then log in the Web application. The database migration process is finished.