Using Database Upgrade Tool

This tool allows you to 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.0.

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 reside.
    • On Windows, the directory is TIBCO_HOME\bw\palettes\smartmapper\7.0\tools.

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

    • On Mac OS, the directory is TIBCO_HOME/bw/palettes/smartmapper/7.0/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 <dbconfig> -ermodel <ER_Model_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.0\tools\logs directory after running the tool.