Page Comparison

...

• 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

...

1. 1. In alias section click on rmsis-h2 (connect to it)
   2. On left hand pane select rmsis-h2 > RMSIS > PUBLIC
   3. Go to SQL pane and write following queries, one per line
      
      1. ALTER TABLE PROJECT ALTER COLUMN VERSION RENAME TO VERSION_NEW;
      2. ALTER TABLE TEST_CASE ALTER COLUMN VERSION RENAME TO VERSION_NEW;
      3. ALTER TABLE REQUIREMENT_HIERARCHY ALTER COLUMN LEVEL RENAME TO LEVEL_NEW;
      4. ALTER TABLE REQUIREMENT_BASELINE ALTER COLUMN LEVEL RENAME TO LEVEL_NEW;
      5. ALTER TABLE ATTACHMENT ALTER COLUMN SIZE RENAME TO SIZE_NEW;
      6. ALTER TABLE REPORTING ALTER COLUMN DOMAIN RENAME TO DOMAIN_NEW;
      7. ALTER TABLE TEST_STEP ALTER COLUMN ACTION RENAME TO ACTION_NEW; (Only for RMsis-1.7.1-r168 and above)
   4. Run queries (CTRL + ENTER)
   5. Now your H2 database is ready for migration

...

1. 1. Open terminal and connect to rmsis_db_1 using MySQL
      
      1. mysql -u<username> -p<password> rmsis_db_1
   2. Run following queries
      
      1. ALTER TABLE  `PROJECT` CHANGE  `VERSION_NEW`  `VERSION` INT( 11 ) NULL DEFAULT NULL;
      2. ALTER TABLE  `TEST_CASE` CHANGE  `VERSION_NEW`  `VERSION` INT( 11 ) NULL DEFAULT NULL;
      3. ALTER TABLE  `REQUIREMENT_HIERARCHY` CHANGE  `LEVEL_NEW`  `LEVEL` INT( 11 ) NULL DEFAULT NULL;
      4. ALTER TABLE  `REQUIREMENT_BASELINE` CHANGE  `LEVEL_NEW`  `LEVEL` INT( 11 ) NULL DEFAULT NULL;
      5. ALTER TABLE `ATTACHMENT` CHANGE `SIZE_NEW` `SIZE` BIGINT( 20 ) NULL DEFAULT NULL;
      6. ALTER TABLE  `REPORTING` CHANGE  `DOMAIN_NEW`  `DOMAIN` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
      7. ALTER TABLE `TEST_STEP` CHANGE `ACTION_NEW` `ACTION` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci; (Only for RMsis-1.7.1-r168 and above)
   3. Now close MySQL connection
   4. Go to your work folder (created in step 3), and dump your RMsis database MySQL file (rmsis_db_1)
      
      1. mysqldump -u<username> -p<password> --no-create-info --skip-add-drop-table rmsis_db_1 > rmsis_db_1.sql
   5. Open this SQL file in VIM
      
      1. Run command
         
         1. :%s/`\(\w\+\)`/\L&/g  (it is to change case of table and column name)
      2. Save and exit editor
         1. :wq

...