Link Details

In November 2006 Microsoft released Visual Studio® Team System Database Edition, also known as DBPro or Data Dude, which 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 this article, I will dig into database unit testing, explain how the feature was implemented, and show you how to perform unit testing of your own database projects.