SQL

SQL Unit Testing Tools

1. PDbSeed

PDbSeed is a database seeding and verification tool written in Python. PDbSeed performs an operation, such as DELETE or INSERT, on a database using an XML dataset file for input/output.
Requirement: Python version 2.3 and 2.4, MySQL

2. SPUnit

SPUnit is an application of the popular xUnit framework concept to enable unit testing of SQL Server stored procedures.
Requirement: Windows NT/2000
Download data: Downloadable files: 631 total downloads to date

3. SQLUnit

SQLUnit is a regression and unit testing harness for testing database stored procedures. An SQLUnit test suite would be written as an XML file. The SQLUnit harness, which is written in Java, uses the JUnit unit testing framework to convert the XML test specifications to JDBC calls and compare the results generated from the calls with the specified results.
Requirement: OS Independent (Written in an interpreted language)
Download data: Downloadable files: 10912 total downloads to date

4. TSqlTest

TSqlTest is a simple, lightweight testing framework for Microsoft SQL Server. It utilizes just two technologies you are already familiar with: T-SQL scripts and .bat scripts. It is intended to be used as part of a continuous integration environment. TSqlTest can be used to test stored procedures, triggers, functions, and database "state".
Requirement: Microsoft SQL Server

5. TSQLUnit

TSQLUnit is a framework to write tests for applications written in Transact-SQL.
Requirement: Python
Download data: Downloadable files: 11547 total downloads to date

6. utPLSQL

utPLSQL is a unit testing framework for programmers using Oracle's PL/SQL language.
Requirement: OS Independent
Download data: Downloadable files: 46818 total downloads to date