Technical Articles: DataConstructor™ - The Basics of Test Driven Database Design

view as a single page

BY: Max Guernsey, III - Managing Member, Hexagon Software LLC

Introduction

There are three things to test for when designing a database. You need to validate that your database does the right thing, that you designed your database correctly, and that whatever changes you are trying to make will be properly applied when the time comes to deploy.

Those already familiar with TDD probably recognize the first and second categories as acceptance and unit tests, respectively. The third category doesn't appear to have a good, industry accepted name but we call it "transition testing" because it tests the transition from one version to the next.

Related Links: DataConstructor