Upgrade HDR FHIR Database Schema to HDR 8.2

If you are already using HDR FHIR 8.1.4 schema, you can directly use HDR FHIR 8.1.4 schema as is for HDR 8.2. No upgrade is required.

To upgrade HDR FHIR 8.1.3 Database schema to HDR8.2, perform the following:

1. Navigate to $HDR_HOME/database/db/fhir/upgrade-schema
2. Run chmod 700 on upgrade_fhir_schema_from_813_to_82.sh
3. Run upgrade_fhir_schema_from_813_to_82.sh
   Example

   sh $HDR_HOME/database/db/fhir/upgrade-schema/ upgrade_fhir_schema_from_813_to_82.sh <ORACLE_HOME> <SYS_USER_NAME> <DB_HOST> <DB_SERVICE_NAME> <DB_PORT> <HDR_FHIR_USER_NAME>
   
   sh upgrade_fhir_schema_from_813_to_82.sh /scratch/app/oracle/product/19c sys localhost servicename 1521 HDR_FHIR

   The script prompts you to enter SYS user password, HDR_FHIR user password, HDR_FHIR user current data tablespace name and HDR_FHIR user current index tablespace name, provide valid values and hit enter. Required database objects like tables, sequences, indexes etc. are upgraded to HDR FHIR 8.2 schema.

   Note:

   The upgrade is not a data migration, it’s only a FHIR schema upgradation to HAPI 6.4.2 version compatible.