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