Data migration steps: merging existing registrations

[mstanton1]

• we are collecting more data when we create a record in modernized MHR so when we move over DB2 data we need to merge this additional data into the data set to retain it

Registrations in the modernized application contain more information than the legacy system, including account id, user id, payment information, registration reports, as well as more details in location, description, and owner groups. To preserve this information as part of the data migration, existing records need to backed up, then restored as one of the final steps in the data migration process.

Create a new ETL process to load PROD Postgres database mhr table data into SANDBOX for merge testing.

[doug-lovett]

Nothing for QA to test at this time so moving to Done. Ran the merge SQL script with October PROD data loaded into the SANDBOX environment. Ran some queries comparing with PROD.