Migrating TIBCO Enterprise Administrator Database from Earlier Version to Version 2.4.1

In TIBCO Enterprise Administrator 2.4.1, H2 database version is upgraded from version 1.4.195 to 2.1.210. You must perform the following steps to migrate your database configured in an earlier version of TIBCO Enterprise Administrator to new format in the version 2.4.1.

    Procedure

  1. Stop TIBCO Enterprise Administrator server.

  2. Take backup of <TIBCO_CONFIG_HOME>/tibco/cfgmgmt/tea/data directory.

  3. Run the following commands:

    Copy 
    cd <TIBCO_HOME>/tea/2.4
    Copy 

    java -cp lib/h2-1.3.176.jar org.h2.tools.Script -url jdbc:h2:<TIBCO_CONFIG_HOME>/tibco/cfgmgmt/tea/data/TEA -script tea.zip -options compression zip
    Copy 

    java -cp lib/h2-1.3.176.jar org.h2.tools.Script -url jdbc:h2:<TIBCO_CONFIG_HOME>/tibco/cfgmgmt/tea/data/TEA-REALM -script tea-realms.zip -options compression zip

    This will create tea.zip and tea-realms.zip file in the current directory.

  4. Install TIBCO Enterprise Administrator 2.4.1. For more information, see Installation.

  5. Copy tea.zip and tea-realms.zip files in <TIBCO_HOME>/tea/2.4.1 directory using the following command:

    Copy 
    cd <TIBCO_HOME>/tea/2.4
    Copy 
    cp tea.zip ../2.4.1
    Copy 

    cp tea-realms.zip ../2.4.1

  6. Run the following commands to restore the database:

    Copy 
    cd <TIBCO_HOME>/tea/2.4.1
    Copy 

    java -cp lib/h2-2.1.210.jar org.h2.tools.RunScript -script tea.zip -url "jdbc:h2:<TIBCO_CONFIG_HOME>/tibco/cfgmgmt/tea/data/TEA;NON_KEYWORDS=KEY,VALUE" -options compression zip variable_binary
    Copy 

    java -cp lib/h2-2.1.210.jar org.h2.tools.RunScript -script tea-realms.zip -url "jdbc:h2:<TIBCO_CONFIG_HOME>/tibco/cfgmgmt/tea/data/TEA-REALM;NON_KEYWORDS=KEY,VALUE" -options compression zip variable_binary

  7. Start the TIBCO Enterprise Administrator server from <TIBCO_HOME>/tea/2.4.1/bin directory and verify if all the data from previous version is migrated to version 2.4.1.