Recipies for Continuous Database Integration
is your database being tested and integrated like your application code? do you have a database integration strategy? do you have a process to upgrade your database as you make subsequent releases? Make the database part of your Continuous Integration cycle and benefit from it.
It?s considered very difficult to integrate the database, the way application
developers integrate their code frequently. Pramod will describe a proven way to
integrate the database with the application code and show a way to make it part
of the same application code repository. The practice of “Continuous
Integration” changed the way software is written, then why not extend the
practice to include database in the Continuous Integration cycle, so that you
can see integrated results of your application and database work.
Every time a new release of the application is deployed, invariably there are
problems with the upgrade/migration of the database. Pramod will show how to
create a process where you can upgrade your production databases using upgrade
scripts created during development time and how these upgrade scripts can be
tested so that you will save time and sleep when deploying applications into
production.
As a series of recipes, Pramod will show how DBAs can be effective members of
evolutionary teams, delivering value and expertise to the team, how your team
can still be distributed across continents and be successful while evolving the
database. The recipes are
Continuously Integrating
Extracting your database in scripts
Using Version control for your database
Automating database or schema creation
Creating objects in your database
Removing database objects
Removing your database
Using the build.properties files
Re-Creating your application database for any build
Making it easy for new developers to join the team
Integrating on every check-in
Strategy for naming Upgrade scripts
BuildNumber
Timestamp
UniqueIdentifier
Release
Automating Database change script creation
Implementing database version checking
Sending database upgrades to customers
About Pramod Sadalage
Pramod Sadalage is the co-author of the 2007 Jolt Productivity Award winning
“Refactoring Databases: Evolutionary Database Development”, a Martin Fowler
signature series book and author of “Recipes for Continuous Database
Integration”. Pramod works as a DBA and developer at ThoughtWorks. He works on
large custom-developed applications that use agile methodologies. While on these
projects, he pioneered the practices and processes of agility in the database.
Pramod writes and speaks about these concepts and practices to help those
interested in using agile practices on databases. He has written and presented
about database administration on XP projects, the adoption of agile processes
with databases, and the impact of agile practices on database administration and
design. Pramod is the owner and founder of the agiledatabases Yahoo! group; he
moderates group discussions and helps group members learn about agile databases.
When he is not working, you can find him spending time with his wife Rupali and
daughter Arula, and trying to improve his running.