...
Restore backup of acceptance accounts, settings and permissions for eMER and CAMIS
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).
Database compare: acc and prod.
Testing, eMER and Acc by Avro Arrows and Medevac.
Testing by Client.
Issues encountered during the refresh of CAMIS production to acceptance:
The amount of time it took: started on Tuesday May 23, 2023.
Not completed as of the morning of June 2, 2023
When the refresh fails the process has to be restarted from the beginning.
server ran out of space (occurred multiple times during the work to refresh it.
the database is > 200gb and the acceptance server won’t support it.
It is not currently possible to clone the CAMIS database from Production to Acceptance:
the database is > 200gb and the acceptance server won’t support it.