Search This Blog

SQL Unit Testing Tools



SPUnit 
Download SpUnit
http://spunit.sourceforge.net/

Description: SPUnit is an application of the popular xUnit framework concept to enable unit testing of SQL Server stored procedures.  SPUnit is (loosely) based on the xUnit family of Unit Test Frameworks. It is intended for testing MS SQL Server stored procedures using actual stored procedures. The idea was to make it really painless to test the code in stored procedures, and facilitate test-first programming of stored procs. It is a port inspired by JUnit, a testing framework for Java, developed by Kent Beck and Erich Gamma, and also, CPPUnit -- a port of JUnit -- developed by Michael Feathers.


Requirement : Windows NT/2000


TSQLUnit
Download TSQLUnit
http://tsqlunit.sourceforge.net

Description: TSQLUnit is a framework to write tests for applications written in Transact-SQL. TSQLUnit is a framework to write tests for applications written in Transact-SQL. It follows the tradition of the "xUnit" framework that is available for almost all programming languages. TSQLUnit is open source, licensed under the LGPL license, which means that it can be used freely even in commercial programs subject to certain restrictions. See the cookbook for an introduction of how to use it.

Requirement: Python


utPLSQL
Download utPLSQL
http://utplsql.sourceforge.net/

Description: utPLSQL is a unit testing framework for programmers using Oracle's PL/SQL language.
Requirement: OS Independent

utPLSQL is a unit testing framework for programmers using Oracle's PL/SQL language. Developed by Steven Feuerstein, author of many books on the subject, it allows the automated testing of packages, functions and procedures. For background on the project and the reasons why this sort of unit testing is a good idea, visit the utPLSQL site of the O'Reilly and Associates Oracle Resource Center.