System and method for controlling the release of updates to a database configuration

Abstract

A program product to perform a method for updating database objects in database servers. The program product causes the computer system to the perform steps of receive user specified database schema files for release to a list of corresponding database servers where modifications are to occur, wherein each schema file includes proposed database object structures, and verify that the schema files contain valid DDL commands. The computer system verifies that the user has proper permissions to modify the database object structures, and compares existing database object structures to the proposed database object structures to determine if the existing database object structures need to be modified. If the exising database object structures need to be modified, then the computer system modifies the existing database object structures, creates release notes that include documentation related to modifications of the database object structures, and sends the release notes to predefined addresses.