Page Comparison

Introduction

There have been some requests, where RMsis users entered some critical data in the embedded database during the evaluation period and at a later date wish to migrate to a production ready DataBase.

...

However, specific installations may have some unique issues. If you face any such issue, please contact support@optimizory.com. Also see the notes at the end of this article.

Supported Platforms

• Linux OS has been used in the procedure described below.
• For migration on MS Windows platform, please use windows versions of all the listed tools. One of our customers has migrated on Windows 7 Platform and shared the following additional points:
  
  • When we installed SQuirrel SQL on our Windows 7 machine, some plugins where not correctly installed although they were selected for installation in the installer.
  • Especially "Copy Table" did not show up in the context menu.
  • After manually installing the plugins in the right place and restarting the tool the context menu was there.

Resources / Tools Required

• You must have JAVA installed on your machine.
• SQuirrel SQL (http://squirrel-sql.sourceforge.net/)
• VIM
• JDBC database drivers
  
  • h2-1.3.160.jar
  • mysql-connector-java-5.1.6.jar
• Blank RMsis database (be sure you use correct database version)
  
  • rmsis_164_blank.sql for RMsis-1.6.4
  • rmsis_167_blank.sql for RMsis-1.6.7
  • rmsis_168_blank.sql for RMsis-1.6.8
  • rmsis_170_blank.sql for RMsis-1.7.0
  • rmsis_171_r168_blank.sql for RMsis-1.7.1-r168
  • rmsis_171_r183_blank.sql for RMsis-1.7.1-r183

Perquisite

• Jira admin access
• MySQL root access

Procedure

1. Installing SQuirrel SQL
   
   1. Download SQuirrel SQL from link given above
   2. Follow installation instructions given on http://www.squirrelsql.org/#installation
   3. Make sure, you enable all the plugins, specially H2 and MySQL database support
   4. Copy provided H2 and MySQL driver file in <SQuirrel Installation directory>/Contents/Resources/Java/lib directory
2. Stop your JIRA instance
3. Take RMsis database backup
   
   1. Go to <Jira Home>/rmsis/db/h2/<Your rmsis version>/rmsis.h2.db
   2. Copy this file and put in your <Work Folder>
      
      1. we will use this folder for most of our activities, so make sure it doesn't contain any other file
      2. creating a new folder is good idea
4. Create two MySQL databases
   
   1. Only one will be used by RMsis, and you can drop other one later
   2. we will assume "rmsis_db_1" and "rmsis_db_2" as two database with user name "rmsis" and password "rmsis"
   3. You can choose different parameters, if you wish
5. Start SQuirrel SQL (follow instructions given on installation page)
6. Connecting to your H2 database file, placed in your work folder
   
   1. Go to Alias > New Alias
   2. Put rmsis-h2 as alias name
   3. From driver select "H2 Embedded"
   4. In URL replace <db-name> with path to <path to work folder>/rmsis
   5. User Name - "sa"
   6. Leave other password blank
   7. Click "Test" for testing your connection, if it fine, press save alias by clicking "OK".

...

17. Go to RMsis, and test if everything is fine.

Have Issues ?

• If the process breaks down in between or if you have any issues, do not proceed and contact support@optimizory.com.
• looking at the complexity of migration, it may not be practical to exchange information on mails. At the minimum, we will need mechanism to view your screen, either through WebEx or Skype. Please ensure that this is possible, before contacting support.

...