Information Technology Reference
In-Depth Information
Revisiting the theme of the topic, database integration is one of the
parts of the Integrate button (see Figure 5-1), because it is based on the
principle that database code (DDL, DML, configuration files, etc.) is,
in essence, no different from the rest of the source code in a system. In
fact, the artifacts related to database integration:
• Should reside in a version control system
• Can be tested for rigor and inspected for policy compliance
• And can be generated using your build scripts
Therefore, the building of the database can be incorporated into a
CI system and can enjoy the same benefits as the rest of the project
source code. What's more, changes to database source code can trigger
an integration build
just as other source code changes do.
Compile
Source Code
Integrate
Database
F
e
e
d
b
a
c
k
Integrate
Run
Tests
Run
Inspections
Deploy
Software
Improving Software Quality and Reducing Risk
Database integration in the Integrate button
FIGURE 5-1
