Migrate Oracle database for Talend Administration Center from an old version to 5.3.1

Overview

You can follow the 5.3.1 migration steps described in section 4.5.1 Clearing your previous Talend Administration Center files.

When you migrate Talend Administration Center from Oracle database in an older version (for example 5.2.1) to 5.3.1, it does not work.

Environment

Migrate from an older version to 5.3.1 by following the steps described in section 4.5.1 Clearing your previous Talend Administration Center files.

Symptoms/Description

According to 4.5.1 Clearing your previous Talend Administration Center files

  • Run the migration script as below (you have to type in the same URL for sourceUrl and targetUrl):
Talend-Studio-win32-x86.exe -nosplash -application org.talend.repository.TalendMigration -consoleLog -data migration-workspace1 -sourceUrl "jdbc:oracle:thin:@localhost:1521:talend" -sourceUser aiming -sourcePasswd aiming -targetUrl "jdbc:oracle:thin:@localhost:1521:talend2" -targetUser aiming1 -targetPasswd aiming1 -vmargs -Xss5m -Xms64m -Xmx1024m
  • Run the migration script as below (The URLs of sourceUrl and targetUrl and sourceUrl should be different):
Talend-Studio-win32-x86.exe -nosplash -application org.talend.repository.TalendMigration -consoleLog  
-data migration-workspace1 -sourceUrl "jdbc:oracle:thin:@localhost:1521:talend" -sourceUser aiming 
-sourcePasswd aiming -targetUrl "jdbc:oracle:thin:@localhost:1521:talend" -targetUser aiming1 
-targetPasswd aiming1 -vmargs -Xss5m -Xms64m -Xmx1024m

 Resolution

Run the 5.2.3 single database migration script:

Talend-Studio-win-x86_64.exe -nosplash -application org.talend.repository.TalendMigration -schema aiming -consoleLog -data migration-workspace jdbc:oracle:thin:@localhost:1521:talend2 aiming aiming

For more information, please refer to https://help.talend.com/display/TALENDENTERPRISEBIGDATAINSTALLATIONANDUPGRADEGUIDE52EN/4.3.1+For+MyS....

For Oracle database, you need to add '-schema <your schema>' in the script.

Version History
Revision #:
1 of 1
Last update:
‎05-11-2017 08:32 PM
Updated by:
 
Labels (1)
Contributors