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.
Sample request form
July 2 2014 Refresh KFS-SUP Environment Request.docx
Refreshes are performed at the start of each month (following a successful month end process). The process to request