...
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).
...