Using Database Upgrade Tool

With this tool, you can upgrade a database used for TIBCO ActiveMatrix BusinessWorks Plug-in for SmartMapper 5.x. After upgrading, the database can be used in TIBCO ActiveMatrix BusinessWorks Plug-in for SmartMapper 7.1.

Prerequisites

Ensure that the SmartMapper Tools component is selected when installing the plug-in.
Note: Ensure that the 5.x database is synchronized and backed up.

Procedure

  1. On a command line, navigate to the directory in which the SmartMapper tools are located.

    • On Windows, the directory is TIBCO_HOME\bw\palettes\smartmapper\7.1\tools.

    • On Linux, the directory is TIBCO_HOME/bw/palettes/smartmapper/7.1/tools.

    • On Mac OS, the directory is TIBCO_HOME/bw/palettes/smartmapper/7.1/tools.

  2. Enter upgrade on the command line and press Enter to get help information.
  3. Enter the following command to migrate the cross-referencing data from the source database to the destination database:

    upgrade -db <db config> -ermodel <ermodel file>

    Note: On Linux and Mac OS, if you use Microsoft SQL Server to run the tool, make sure you enclose the database URL in quotation marks ("), unless you use the db.properties file to configure the database connection.

    See more information in Parameters for SmartMapper Tools.

Result

A log file named upgrade.log is generated under the TIBCO_HOME\bw\palettes\smartmapper\7.1\tools\logs directory after running the tool.