By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,127 Members | 1,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,127 IT Pros & Developers. It's quick & easy.

Unit Testing

P: n/a
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

Sep 30 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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" <se****@nospam.ehmail.com> wrote in message
news:OG******************@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

Oct 1 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.