Working with the DB Migration Tool

The Fiorano DB Migration Tool is used to migrate the database of FioranoMQ Server file from an older version to the newer version.

The typical structure of the FioranoMQ database is explained in the Working with the DB Recovery Tool section. Please refer to it to understand the structure.

FioranoMQ needs to be shut down in order to use the migration tool.

Open the Migration script file

To use the DB Migration tool, go to:

Windows

%FIORANOMQ_HOME%/fmq/bin/Windows_Migration

Linux

$FIORANOMQ_HOME/fmq/bin/Linux_Migration 

List of Files

The Migration folder contains the following files:

• migrate.bat (for Windows) and migrate.sh (for Unix):
  These scripts convert databases from older FioranoMQ versions (for example, FioranoMQ2007) to the latest format. You must specify the older build number, the installation directory of the older version, the profile name, and the path to its database. All of these values are defined in the migration.properties file located in the Profiles folder.

  

  After converting from DB prior to FMQ2008(Build:4507) e.g., FioranoMQ2007SP3 to the latest version, the SDB will be changed in such a way that password of all the users will be reset to "passwd". So the user has to manually change the password through WMT console before starting the application.

• README.txt
  This file has the steps to migrate from the older version (similar to what we have in this section)

Set the required input parameters

All required inputs for running the migration—such as the old build number, old installation path, profile name, and database location—must be set in the migration.properties file. This properties file drives both the migrate.bat and migrate.sh scripts.

Avoid giving space between '=' and the values assigned. Do not end the path with '\' slash ('/' for Unix).

Property	Description
OLD_BUILD_NUMBER	This denotes the build number of the OLD_DB_PATH installation from which migration is taking place. Example CODE OLD_BUILD_NUMBER=4363
OLD_FIORANO_HOME	This denotes the home directory of the FIORANOMQ2007(older) installation. Example Windows: If the directory structure is C:\Program Files\Fiorano\FioranoMQ2007SP2, then the home directory is entered as: CODE OLD_FIORANO_HOME= C:\Progra~1\Fiorano\FioranoMQ2007SP2 Without the slash at the end and make sure the file path does not contain any whitespace. If whitespace exists, that must be truncated appropriately, for example, Program Files becomes Progra~1 Linux: If the directory structure is /home/Fiorano/FioranoMQ2007SP2/fmq/bin, then the home directory is entered as: CODE  OLD_FIORANO_HOME=/home/Fiorano/FioranoMQ2007SP2 Without the '/' slash at the end
PROFILE	This denotes the profile whose DB is being migrated from FioranoMQ2007 to FioranoMQ11. Example CODE PROFILE=FioranoMQ
OLD_DB_PATH	This denotes the location of the old database. Example Windows: If the database is located at C:\Program Files\Fiorano\FioranoMQ2007SP2\fmq\profiles\FioranoMQ\run, then enter the following value CODE OLD_DB_PATH=C:\Progra~1\Fiorano\FioranoMQ2007SP2\fmq\profiles\FioranoMQ\run Without the slash at the end and make sure the file path does not contain any whitespace. If whitespace exists, that must be truncated appropriately, for example, Program Files becomes Progra~1 Linux: If the database is located at /home/Fiorano/FioranoMQ2007SP2/fmq/profile/FioranoMQ/run, then enter the following value: CODE  OLD_DB_PATH=/home/Fiorano/FioranoMQ2007SP2/fmq/profile/FioranoMQ/run Without the '/' slash at the end
NEW_FIORANO_HOME	This denotes the home directory of the new installation. Example Windows: If the database is located at C:\Program Files\Fiorano\FioranoMQ11, then the home directory is entered as: CODE NEW_FIORANO_HOME=C:\Progra~1\Fiorano\FioranoMQ11 Without the slash at the end and make sure the file path does not contain any whitespace. If whitespace exists, that must be truncated appropriately, for example, Program Files becomes Progra~1 Linux: If the database is located at /home/Fiorano/FioranoMQ11/fmq/bin, then the home directory is entered as: CODE NEW_FIORANO_HOME=/home/Fiorano/FioranoMQ11 Without the '/' slash at the end

Execute the Migration Script

After initializing the parameters in the migration.properties file, run the migration script using the command:

migrate.bat

migrate.sh

Use the new database

Identifying the new DB

Upon running the script, the new database will be created at %NEW_FIORANO_HOME%\fmq\profiles\%PROFILE%\ with the name "new_run".

Windows

If the NEW_FIORANO_HOME is C:\Program Files\Fiorano\FioranoMQ11XX and the PROFILE is FioranoMQ, then the new database would be available in the new_run folder at C:\Program Files\Fiorano\FioranoMQ11XX\fmq\profiles\FioranoMQ.

Linux

If the NEW_FIORANO_HOME is /home/Fiorano/FioranoMQ11XX and the PROFILE is FioranoMQ, then the new database would be available in the new_run folder at /home/Fiorano/FioranoMQ11XX/fmq/profiles/FioranoMQ/new_run.

Running the Server

To use the new DB, perform one of the following actions while running the server:

1. 1. Use the new_run DB with the -dbPath argument while starting the server
   2. Rename the DB to "run" to start the server without the -dbPath argument