Unit Testing

[serge]

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

[John Bell]

Re: Unit Testing

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

"serge" <sergea@nospam. ehmail.com> wrote in message
news:OG%_e.4658 $f_3.50869@webe r.videotron.net ...[color=blue]
> 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
>
>
>[/color]