TRANSACTION-BASED PSEUDO-SCRIPT GENERATION FOR SCHEDULING AND IMPLEMENTING DATABASE SCHEMA CHANGES

摘要

Embodiments are disclosed for implementing database schema modifications. In some embodiments, pending schema object changes are determined for a first database. An object tree is generated including populating the object tree with object definition nodes for schema objects to be modified by the pending schema object changes. The object definition nodes are modified in accordance with the pending schema object changes. Based on the modified object definition nodes, single-operation transactions are sequentially generated that each correspond to one of the pending schema object changes, wherein at least two of the single-operation transactions correspond to one of the pending schema object changes. A database schema is modified including executing change statements derived from the single-operation transactions.