System and method for testing and promoting database update code

摘要

A system and method for testing and promoting database update code is presented. A programmer uses a SPUFI machine that enables him to test SPUFI code on error prone data that is copied from a customer's actual database. The SPUFI machine sends an access request to the customer prior to copying the actual database. Once the programmer has the SPUFI code working properly, the SPUFI machine sends the SPUFI code to a staging area. The staging area does not allow code changes prior to executing the SPUFI code on the customer's actual database. The customer is informed whether the SPUFI code corrects the actual database.