Using Migration Tool

With this tool, you can migrate relationship data and entity data in an existing database to another empty database.

Prerequisites

Ensure that the SmartMapper Tools component is selected when installing the plug-in.
Note: Ensure that the database to which the data is migrated is empty.

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 migrate 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:

    migrate -src <db config> -dest <db config>

    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 migrate.log is generated under the TIBCO_HOME\bw\palettes\smartmapper\7.1\tools\logs directory after running the tool.