Process Overview

The UITS DBA team developed and maintains a series of scripts to refresh the non-prod Kuali databases from the most recent (nightly) production schema level export file.  This process allows the Kuali non-prod environments to contain a highly relevant set of data for development. , testing, training, and production trouble-shooting.  The scripts are automated by environment in Control-M jobs. Refreshes are initiated by submitting a Control-M job request form to scheduling@uconn.edu, The requester simply enters the common name of the environments to refresh, in the order desired.  The automated jobs contain all of the actions necessary to take the application servers offline, perform the refresh, and then restore the application servers to an available state.  The refresh process also includes scripts to restore the test version of the encryption key and java object, and to falsify and re-encrypt the contents of all sensitive data fields.

Sample request form

July 2 2014 Feb 3 2015 Refresh KFS -SUP Environment Environments Request.docx

Refreshes are performed at the start of each month (following a successful month end process).  The process to request