The Fiorano DB Migration Tool is used to migrate the database of FioranoMQ Server file from an older version to the newer version.
Following are the steps to use the DB Migration tool:
Open the Migration script file
To use the DB Migration tool, go to:
List of Files
Following are the files present in the Migration folder:
migrate.bat (migrate.sh for Unix):
This script is used for migrating from older versions such as FioranoMQ2007,etc. to FioranoMQ11XX.
This file has the script to convert the database of an older version e.g.FioranoMQ2007 installation into a FioranoMQ11XX compatible format. The input parameters that are required by this script file are the build no of the older version e.g. FioranoMQ2007 installation, the install path of the older version e.g. FioranoMQ2007, the profile name and the location of its database.- 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
Input parameters need to be provided in the bat file; parameters that are used to run the 'migrate.bat' (or 'migrate.sh') script file are listed below.
Property | Description |
---|---|
OLD_BUILD_NUMBER | This denotes the build number of the OLD_DB_PATH installation from which migration is taking place. Example |
OLD_FIORANO_HOME | This denotes the home directory of the FIORANOMQ2007(older) installation. |
PROFILE | This denotes the profile whose DB is being migrated from FioranoMQ2007 to FioranoMQ11. Example |
OLD_DB_PATH | This denotes the location of the old database. |
NEW_FIORANO_HOME | This denotes the home directory of the new installation. |
Execute the Migration Script
After initializing the listed values in the migrate.bat file, run the migration script using the command:
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".
Running the Server
To use the new DB, perform one of the following actions while running the server:
- Use the new_run DB with the
-dbPath
argument while starting the server - Rename the DB to "run" to start the server without the
-dbPath
argument
- Use the new_run DB with the