(BQ) Part 2 book "Continuous integration" has contents: Continuous database integration, continuous testing, continuous feedback, continuous deployment, continuous inspection. | Part II Creating a Full-Featured CI System 105 This page intentionally left blank Chapter 5 Continuous Database Integration Automate Database Integration Use a Local Database Sandbox Give Developers Capability to Modify the Database Use a Version Control Repository to Share Database Assets Make DBA Part of Development Team Things do not change; we change. —HENRY DAVID THOREAU Continuous Database Integration (CDBI) is the process of rebuilding your database and test data any time a change is applied to a project’s version control repository. Do you ever feel like your source code and database are operating in different “galaxies” throughout the development lifecycle on projects? As a developer, you may wait several days for a change to the database. You may even be restricted from making minor test data changes, or are afraid to make data changes for fear of ruining the one shared database for fellow developers. Situations like these are not unusual, and effectively utilizing CDBI can help alleviate some of these challenges and many others as well. 107 108 Chapter 5 ❑ Continuous Database Integration Revisiting the theme of the book, 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 .
