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; (RMsis-1.7.1-r183 and below)
      4. ALTER TABLE REQUIREMENT_BASELINE ALTER COLUMN LEVEL RENAME TO LEVEL_NEW; (RMsis-1.7.1-r183 and below)
      5. ALTER TABLE ATTACHMENT ALTER COLUMN SIZE RENAME TO SIZE_NEW; (RMsis-1.7.1-r183 and below)
      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)
      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.

...