April 2008 Blog Posts
Problem
Automatic database updates in a Continuous Integration Server (i use CruiseControl.NET) has always been a missing link for me. There are two aspects of it:
unit-testing database-dependant classes.
publishing database changes to the staging environment (mainly for web project).
Unit testing database-dependant classes (i use NUnit) can be easily solved by just having our MDF file (in case of SQL Server database) in the source control repository (i use Subversion). Making changes to the database is easy, and those changes will be unit-tested by our CI Server when we comming...