WARNING: This utility is still in beta. Please inform us before using this utility. 

...

• Download and install JAVA 1.8 and set the JAVA_HOME Variable.

• Shut down JIRA before taking the database dumpExecute the Migration Validator before performing the backup and restoration using this utility. See https://docs.optimizory.com/x/qJ7B for details.

Steps to create the dump of existing database:

1. Download the migration utility(migrateutil-1.0.0-RC-04.tar) and store it on the JIRA+RMsis server. (Please send a mail to support@optimizory.com to get the link to download the utility)

   •  

   • Here, migrateutil-1.0.0-RC-04.tar is stored in the "/Users/pritam/path/to/migrationUtility" directory.

2. Extract the contents of the tar file. 

   •  

   • A directory with name "migrateutil-1.0.0-RC-04" will be created.
     

3. Switch to the directory migrateutil-1.0.0-RC-04 and create a directory with name "backup" where the contents of the existing database will be dumped.

   •  
   • Here, a directory named "backup" is created which will be used later to store the database backup.
4. Create a copy of the file migrateutil-1.0.0-RC-04/conf/jdbc.properties.template and save it with the name "jdbc.properties" and then open it in the text editor. The contents of the file is displayed in the image attached below:
   • 
5. The newly created file will be used by the utility to access the RMsis database. You will have to update the database connection details in the file. The following properties needs to be uncommented and updated:
   1. jdbc.driver: Uncomment this field and leave it's value to default (as already present in the jdbc.properties file). This field is used to identify the jdbc driver used to connect to RMsis database.
   2. jdbc.url : Uncomment this field and update the IP address and port number of the database server if required. 
   3. db.typeName : Uncomment this field and leave it's value to default. This field is used to identify the type (H2/MySQL/PostgreSQL/Oracle/SQL Server) of database in use with RMsis.
   4. db.schemaName : Uncomment this field and replace rmsisDatabaseName with the name of the database being used for RMsis.
   5. jdbc.username: Uncomment this field and and replace it with the username used to connect to RMsis database server.
   6. jdbc.password: Uncomment this field and replace it with the password used to connect to RMsis database server.
      
      Note: To uncomment a field, remove the "#" symbol at the beginning of the field name. 
   • For example, if  you are using a MySQL database with RMsis having name "rmsisDb". The content of the updated file will look like the image mentioned below:
     

6. Execute the migration utility using the following command to dump the database content: 

   • -b switch is used to specify the location of the directory where the backup will be stored, here it is the location of the "backup" directory created in step 3.

   • -v switch is used to specify the version of RMsis presently in use. Here, it is v1.8.8-r301. Format used: v<RMsisVersionNumber>-r<RMsisBuildNumber>

   • -j switch is used to specify the location of the jdbc.properties file created and updated in step 4 & 5.

   • dump is the name of the command which directs migration utility to create the backup of RMsis database

     Code Block
     title Command to create the backup using migration utility
     ./bin/migrateutil -b /path/to/migrationUtility/backupDirectory/ -v v1.8.8-r301 -j /path/to/migrationUtility/conf/jdbc.properties dump   Example: ./bin/migrateutil -b /Users/pritam/path/to/migrationUtility/migrateutil-1.0.0-RC-04/backup/ -v v1.8.8-r301 -j /Users/pritam/path/to/migrationUtility/migrateutil-1.0.0-RC-04/conf/jdbc.properties dump

   • 
     

7. Upon successful execution, the database content will be dumped in the directory specified to create the backup using the -b switch. Here, a directory named "301-1.8.8-2017-05-13"  is created inside the "/Users/pritam/path/to/migrationUtility/migrateutil-1.0.0-RC-04/backup/" directory.

8. Copy the backup folder on the destination server. The contents of this folder will be used to restore the RMsis data on destination database.

...