Using Differencing Tool

With this tool, you can compare two SmartMapper ER Models.

Prerequisites

Ensure that the SmartMapper Tools component is selected when installing the plug-in.

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 diff on the command line and press Enter to get help information.
  3. Enter the following command to compare two SmartMapper ER Models:

    diff -src [ear <EAR file directory!jar file directory!ER Model file path>] | [file <ER Model file path>] | [db <type> <driver> <url> <username> <password>] | [db < alias>] | [jar <jar file directory!ER Model file path>] -dest [ear <EAR file directory!jar file directory!ER Model file path>] | [file <ER Model file path>] | [db <type> <driver> <url> <username> <password>] | [db < alias>] | [jar <jar file directory!ER Model file path>]

    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.
    Note: On Linux and Mac OS, add backslashes (\) before exclamation points (!) to separate EAR file directory and JAR file directory from ER Model file in this command.

    For example:

    diff -src file /opt/test.smartmapperermodel -dest ear /opt/test.ear\!test.jar\!Resources/project/SmartMapperERModel.smartmapperermodel

    See more information in Parameters for SmartMapper Tools.

Result

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