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
  • rmsis_171_r200_blank.sql for RMsis-1.7.1-r200
  • rmsis_178_r206_blank.sql for RMsis-1.7.8-r206
  • rmsis_186_r297_blank.sql for RMsis-1.8.6-r297

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; (Only for RMsis-1.7.1-r183 and earlier versions)
      4. ALTER TABLE REQUIREMENT_BASELINE ALTER COLUMN LEVEL RENAME TO LEVEL_NEW; (Only for RMsis-1.7.1-r183 and earlier versions)
      5. ALTER TABLE ATTACHMENT ALTER COLUMN SIZE RENAME TO SIZE_NEW; (Only for RMsis-1.7.1-r183 and earlier versions)
      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 abovelater versions)
      8. Update rmsis_sync_status SET LAST_SYNC_AT='1980-01-01 00:00:00' WHERE LAST_SYNC_AT < '1980-01-01 00:00:00'; (Only for RMsis-1.8.6-r297)
   4. Run queries (CTRL + ENTER)
   5. Now your H2 database is ready for migration

...

1. 1. Go to Alias > New Alias
   2. Put rmsis-mysql as alias name
   3. Select "MySQL Driver" for driver
   4. In URL put jdbc:mysql://<hostname>:<port>/<dbname>?useUnicode=true&characterSetResults=UTF-8&characterEncoding=UTF8
      
      1. replace <hostname> with MySQL host name, localhost if it is running on localhost,
      2. replace <port> with MySQL port, 3306 is default
      3. replace <dbname> with rmsis_db_1 (created in step 4)
   5. Put user name and password, that you can created in step 4
   6. Test connection and save it once it is done.

...

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; (RMsis-1.7.1-r183 and below)
      4. ALTER TABLE  `REQUIREMENT_BASELINE` CHANGE  `LEVEL_NEW`  `LEVEL` INT( 11 ) NULL DEFAULT NULL; (RMsis-1.7.1-r183 and below)
      5. ALTER TABLE `ATTACHMENT` CHANGE `SIZE_NEW` `SIZE` BIGINT( 20 ) NULL DEFAULT NULL; (RMsis-1.7.1-r183 and below)
      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

...