Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

...