CAMIS is a protected B medical application.
When a database refresh is performed precautions need to be taken to ensure that users connecting to acceptance cannot view unauthorized data. MERS themselves will not be deleted. Links to MER documents will be broken but the rest of the view will be viewable.
The TWOFA database should be refreshed at the same time when CAMIS db is refreshed because they have to be in sync.
Concerns that were identified were:Privacy/Security: medical information (especially documents)
Portal trial setup would need to be redone
CAMIS/eMER accounts - 2FA links would be broken
...
Refresh from prod but delete assessments past a certain date (2000) and all documents
There is an old sanitize script that we can possibly use as a starting point: \\tc4s0a\Groups\aara\aarad\dba\camis\scripts
MERs won't be deleted - if they click on the button to view the eMER file it will break but the rest of the MER info is still there
Backup document info (blobs and others) for portal trial and then update all of it once refresh is done
All the data in the account tables in CAMIS need to be backed up and then put back in once the refresh is done
see also Draft: CAMIS refresh - impacts / considerations re 2FA data
PROPOSED PLAN (associated subtask placeholders are created).
...
Create an SM-GS change request ticket: it needs to take place asap to minimize the amount of CAMMS data that would be lost.
The DBAs should
Check for and recompile all invalid objects
Verify that the db links still point to Acc (note: based on feedback from corporate DBAs these are not typically refreshed).
Backup accounts/permissions and settings, as applicable (eMer and CAMIS) Identify and Backup CAMIS tables containing eMER and CAMIS account information, permissions for Acceptance
Review / update sanitize script: Review "sanitize" script
...
Once Refresh is completed on acceptance
Restore backup of acceptance accounts, settings and permissions for eMER and CAMISRun the latest sanitize_script.sql . It is backed up in \\tc4s0a\Groups\aara\aarad\dba\camis\scripts
Verify that records identified for deletion / sanitization are removed/updated.
Check for invalid objects that need to be recompiled.
Verify that the db links still point to Acc (note: based on feedback from corporate DBAs these are not typically refreshed).Restore backup of acceptance accounts, settings and permissions for eMER and CAMIS
Database compare: acc and prod.
Testing, eMER and Acc by Avro Arrows and Medevac.
Testing by Client.
...