Techniques for managing multiple versions of relational database schema
data are described. Schema data associated with multiple versions of a
relational database are maintained according to a database schema version
management structure. Laws of set theory are applied to the structured
database schema data to identify data definition language (DDL) and data
manipulation language (DML) scripts that are associated with a particular
version of the relational database. The identified scripts are then
copied into an installation file that can be executed to create a full
install of the particular version of the relational database. Similarly,
laws of set theory are applied to the structured database schema data to
identify DDL scripts, DML scripts, and drop scripts that are to be
applied to upgrade from one version of the relational database to a newer
version of the relational database.