Information Technology Reference
In-Depth Information
Test and inspect your database scripts and code.
Change database development practices by ensuring that all database
integration is managed through the build scripts, that all database
assets are checked into version control, and that all developers
(who interact with the database) have a database sandbox.
Table 5-2 summarizes the practices covered in this chapter.
CI Practices Discussed in This Chapter
TABLE 5-2
Practice
Description
Automate database
integration
Rebuild your database and insert test data as part of
your automated build.
Use a local database
sandbox
All developers should have their own copy of the
database that can be generated via SQL scripts. This
can be on their workstations or even shared on a
development server—as long as all developers have
their own copy on this shared server.
Use a version control
repository to share
database assets
Commit your DDL and DML scripts to your version
control system so that other developers can run the
same scripts to rebuild the database and test data.
Give developers the
capability to modify
the database
Avoid the DBA bottleneck that occurs when database
changes are restricted to just one or two people. Give
developers the capability to modify the DDL and DML
scripts and commit them to the version control
repository.
Make the DBA part
of the development
team
Be sure the DBA can run the same automated
build—which includes a database rebuild that other
developers run—to ensure consistency. By making
the DBA a part of the development team, the shared
experiences can benefit both the database and the
development teams.
Let's see how Julie, Scott, and Nona are doing now that they're
using CDBI.
Nona (Developer): I need to refresh my test data. What do I need to
do?
Scott (Technical Lead): Just run ant db:refresh from the command
line. Before you do that, get the latest changes out of Subversion by
typing ant scm:update , because I made a few changes to the USER
database table and the source code that uses this change.
Search WWH ::




Custom Search