Hi
I assume you have seen
"TSQLUnit testing framework"
http://tsqlunit.sourceforge.net/ "TSQLUnit Cookbook"
http://tsqlunit.sourceforge.net/tsqlunit_cookbook.htm Check out the links page for related information.
You may find more information on NUNIT and Extreme Programming, but not all
of this may be applicable for SQL Server stored procedures.
http://nunit.org/index.html IMO the advantage of having such a repeatable test suite is the ability to
run it for subsequent changes/releases and have a high degree of confidence
that nothing has broken. You do not have to have be using XP as a
methodology to gain benefits from this approach.
John
[quoted text, click to view] "serge" <sergea@nospam.ehmail.com> wrote in message
news:OG%_e.4658$f_3.50869@weber.videotron.net...
> I've started researching on Unit Testing and I must admit
> I had never heard of Unit Testing until a couple of months
> ago. Obviously I am interested in Unit Testing Stored
> Procedures.
>
> I read the TSQLUnit documentation (not all of it) and i also ran
> into a newsgroup post saying TSQLUnit is very small compared
> to NUnit. The conclusion I am making out of this post is that
> I should rather spend time resarching/reading about NUnit than
> TSQLUnit. Is that a good assessment?
>
> I would like to you what you use and if you use actually
> Unit Testing or some other method? I ran into White Box/Black Box
> QA testing. All these are new to me. Any good place to read about
> "Extreme Programming"? I ran into one link that I saved it at work.
> That's one place i will read more.
>
> Any links, documentation or books you would suggest?
> I searched Amazon and I didn't find anything interesting
> regarding SQL Server and Stored Procedures.
>
> Thank you
>
>
>
