Apply Test-Driven Development to your Database Projects

Visual Studio Team System Database Edition, also known as DBPro or Data Dude, introduced a product lifecycle methodology to database development. DBPro also introduced a database unit-testing designer that makes it easy to either generate or write T-SQL-oriented unit tests to verify database objects prior to deployment.

In the Launch issue of MSDN Magazine, Jamie Laflen digs into database unit testing, explaining how the DBPro unit-testing designer was implemented, and showing you how to perform unit testing of your own database projects.

Don't forget to check the MSDN Magazine archives for more on testing and database development.

Technorati Tags: database, SQL Server, testing, Visual Studio, DBPro