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, 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

Introduction

The following article came about after reading reading Evolutionary Database Design 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.