The version 0.5 database upgrade made significant changes to the data model and this requires a special data migration process to ensure data integrity if the given database instance has utilized the Data Validation Module to evaluate QC criteria. If the data rules are consistent over time then a PL/SQL script can be used to migrate the data into the new data model, otherwise a manual migration process must be conducted.
- Determine if the validation rules from the old data model can be migrated using the automated script
- Execute part 1 of the version 0.5 upgrade
- Migrate the DVM data to the new data model using the migration script
- Verify the DVM data in the new data model using the verification script, if the return value is "Y" then the data was migrated successfully
- Execute part 2 of the version 0.5 upgrade