Migrate Permits Database from Current Version to 12.1 Using jdbcmk

This guide helps you transition from the WGS permits schema (PERMITSV3_) to the new Core permits schema (CORE_PERMITS_) using the jdbcmk utility.

It is recommended to back up the entire database before starting the upgrade process.

Back up existing permits data (on your current version)

• Option A: Use REST API
  Endpoint: /secure/v1/secure-data/backup

• Option B: Use Security Manager
  Navigate to: Export Data → Data Backup

Create Core Permits Database Objects

1. Run the jdbcmk utility

   • From your shell: ./jdbcmk.sh
     

2. From the jdbcmk main menu, select Option 1.
   
   

3. Then select Option 1 from CORE DATABASE menu, to create the Core Permits Database objects.

Remove WGS Permits Database Objects

1. Run the jdbcmk utility

   • From your shell: ./jdbcmk.sh
     

2. From the jdbcmk main menu, select Option 2.
   
   

3. Then select Option 7 from WSG/MANAGE DATABASE menu, to remove the WGS permits database objects.

Restore permits data (on version 12.1)

• Option A: Use REST API
  Endpoint: /secure/v1/secure-data/restore

• Option B: Use Security Manager
  Navigate to: Import Data → Restore Data