---
title: "Article: Continuous Database Integration by Peter Hancock"
url: "https://osherove.com/blog/2004/11/12/article-continuous-database-integration-by-peter-hancock.md"
canonical: "https://osherove.com/blog/2004/11/12/article-continuous-database-integration-by-peter-hancock.html"
published: "2004-11-12T11:51:00"
updated: "2004-11-12T11:51:00"
tags: ["Agile Related", "Cool Articles"]
author: "Roy Osherove"
description: "Peter Hancock has written a very interesting and real world article about his way of creating an automated database deployment task. It's not a simple thing, but it's possible with a bit of work. He's using NAnt,…"
usage: "Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page)."
license: "https://creativecommons.org/licenses/by/4.0/"
---

# Article: Continuous Database Integration by Peter Hancock

By Roy Osherove November 12, 2004 In [Agile Related](https://osherove.com/blog/category/agile-related), [Cool Articles](https://osherove.com/blog/category/cool-articles)

**Historical article** · Originally published November 12, 2004; technical details may be outdated.

[Peter Hancock](http://dotnetjunkies.com/WebLog/piquet/) has written a very interesting and real world article about his way of creating an automated database deployment task. It's not a simple thing, but it's possible with a bit of work.

He's using NAnt, CruiseControl.net and osql.exe.

I'm planning a writeup of my own project build management experiences later, but this is very very interesting.

## [Continuous Database Integration](http://dotnetjunkies.com/WebLog/piquet/articles/31254.aspx)

## Introduction

_The following article came about after reading reading_ [_Evolutionary Database Design_](http://www.martinfowler.com/articles/evodb.html) _by Martin Fowler and Pramod Sadalage.  The concepts were great, but I couldn't find anything on the web that really showed how to go about implementing it.  So I decided to have a go at it myself from the ground up.  Following is how I've managed to do it for the current project I'm working on._

## More in Agile Related

[All posts in Agile Related](https://osherove.com/blog/category/agile-related)

- Nov 27, 2004

    ### [Can Agile project management software succeed?](https://osherove.com/blog/2004/11/27/can-agile-project-management-software-succeed.html)

- Nov 24, 2004

    ### [Not Invented here](https://osherove.com/blog/2004/11/24/not-invented-here.html)

- Nov 7, 2004

    ### [IntelliJ IDEA keeps getting better](https://osherove.com/blog/2004/11/7/intellij-idea-keeps-getting-better.html)

- Nov 7, 2004

    ### [The Road to Agile: a series of online presentations](https://osherove.com/blog/2004/11/7/the-road-to-agile-a-series-of-online-presentations.html)


---

## About the author

**Roy Osherove**: Senior Solutions Architect at AWS working on AI for production and AI-driven development; author of The Art of Unit Testing and Elastic Leadership, with about 20 years of consulting and training on unit testing, TDD, team leadership and continuous delivery.

### Sites

- [RobotPaper](https://robotpaper.ai/): This blog: AI patterns and anti-patterns, AI and coding agents, and engineering leadership.
- [osherove.com](https://osherove.com): Roy's personal site. Author of The Art of Unit Testing and Elastic Leadership; consulting and training on unit testing, TDD, team leadership and continuous delivery, plus about 20 years of blog posts.
- [The Art of Unit Testing](https://www.artofunittesting.com): The Art of Unit Testing, 3rd Edition (Manning): readable, maintainable, trustworthy unit tests, plus TDD workshops in C#, JavaScript, Java and Kotlin.
- [5whys.com](https://www.5whys.com): Roy's writing on software team leadership: self-organizing teams, surviving chaos, learning mode and the Elastic Leadership model.
- [Pipeline Driven](https://pipelinedriven.org): Continuous delivery and DevOps practices: build patterns, pipeline-friendly testing, DevOps metrics and enterprise DevOps.
- [Elastic Leadership](https://www.elasticleadership.com): Elastic Leadership, Roy's framework for software team leaders (survival, learning and self-organizing modes).

### Social

- X: https://x.com/royosherove
- LinkedIn: https://www.linkedin.com/in/osherove/

### Contact

- Contact form: https://forms.gle/jQSx5KoXvrVA1JCK7

### License

Licensed under CC BY 4.0 — reuse, quote and adapt with attribution (Roy Osherove, link to the original page). License: https://creativecommons.org/licenses/by/4.0/