Information Technology Reference
In-Depth Information
Another important capability you gain by automating your data-
base integration is that everyone on the team will be able to create a
local instance of the database on their workstations. Every team mem-
ber can then create a database “sandbox” to make and test database
changes without affecting others. If your database integration is
scripted, creating a new database instance is a push-button affair; con-
versely, if you don't automate your database integration, it is more dif-
ficult to recreate your database and run tests on your workstation.
Figure 5-3 provides an illustration of each developer using a local
database instance.
Using automated database integration, you are able to get the latest
version of your database scripts along with your application source
code. Each developer is able to create a local instance of the database,
modify the version of the database on his workstation, test the
changes, and commit the changes back to the repository. These
changes will be integrated and tested with the rest of the software as
part of the CI system. When another developer refreshes her private
workspace with changes from the repository, the database changes are
SQL
Scripts
SQL
Scripts
SQL
Scripts
Build
Scripts
Build
Scripts
Build
Scripts
<@>
<@>
<@>
Local
Database
Sandbox
Local
Database
Sandbox
Local
Database
Sandbox
Developers
FIGURE 5-3
Each developer uses a local database sandbox
Search WWH ::




Custom Search