I am looking for a unitttest and code-coverage tool for TSQL sprocs. Can anyone recommend a good one? Commercial or free.
+1
A:
I've used tsqlunit, and just noticed this from Microsoft, which appears to be Database Unit Testing. There's a series of articles on Simple-Talk by Alex Kuznetsov as well, for you to look at if you haven't already.
Randolph Potter
2009-11-11 21:49:48
VSTS for Databases doesn't produce Sproc code coverage, unfortunately. We ended up using SQLUnit as it's is easier to setup than VSTS for Databases. Still looking for a good code coverage solution..
Yuri
2009-11-12 18:31:49
I'm interested in how this turns out. Might make my life easier too.
Randolph Potter
2009-11-12 19:44:10
A:
Jeremiah Peschka started building dynamic T-SQL to call every stored proc in the database, but I haven't used this personally:
Brent Ozar
2009-11-13 02:41:53