Sachin Rekhi on Database Unit Testing

RobCaron

17 Jul 2006 4:43 AM

Comments 3

I don't know how popular the blogs from the Team Edition for Database Pros team have grown, so I wanted to draw some attention to Sachin Rekhi's recent posts on database unit testing.

What is database unit testing?

Creating your first database unit test

Types of database unit tests

Database Unit Test Verification

From: Sachin Rekhi's Ramblings

Sachin Rekhi is a Program Manager on Team Edition for Database Professionals and has one of the most information-rich blogs for it. If you have any interest in database development and you haven't added this blog to your reading list, you're really missing out.

981

Tags: vsts | team system

Team System

Comments

OA

17 Jul 2006 5:13 AM

Great~~~thanks
Dylan

17 Jul 2006 4:17 PM

IMO, the DB Unit Tests don't seem so valuable to me yet. I would love to be able to write tests against my stored procedures at the SQL level. But the things I want to test are that my GetTop10Products stored procedure actually returns the top 10 products based on the sample data I setup. I don't want to test that it returns a non-empty recordset, or that it returns a recordset with a rowcount of 10. I need to know if the actual data returned is correct (eg. that it returns products 13, 81, 91, 43...29, etc)

Until we get to the point where tests such as that are easy, I don't think we will be realizing the true value of database unit tests.
Operatoru' Bstrd din Iad

19 Jul 2006 3:58 AM

Despre database unit testing, aiciIn general despre Team SystemTeam System Dev Center, hostat tot pe...

Rob Caron

Sachin Rekhi on Database Unit Testing

Sachin Rekhi on Database Unit Testing