Friday, 16 March 2012

Database unit testing with tSQLt

I am currently working on a project that has a fair amount of backend database processing happening.  I have got a fair amount of TDD experience in a C# environment and have found that once you get into TDD it becomes a way of life.  As such, I wanted to apply the same approach to my database development. 

After a bit of researching I stumbled across an Open Source unit testing framework for SQL Server called tSQLt.  I have been using it for a few weeks now and yesteday I past the 100 test mark in the project I am working on.  It took me a little while to get up and running with some of the concepts and idea's around tSQLt unit testing, but I am already feeling very comfortable writing database unit tests using tSQLt.

There is a very good series of blog posts on tSQLt already at http://datacentricity.net/tag/tsqlt/
Over the next few days (I hope).  I will try to put together a series of post's showing the basics working of each test type without any extra logic to get in the way of what is going on.

No comments:

Post a Comment