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
See More
Functional Test Tools – All free and Open-Source
Performance Test Tools – All free and Open-Source
Security Test Tools – All free and Open-Source
Unit Testing Tools – All free and Open-Source
Unit Test C/C++
Unit Test Java
Unit Test .Net
Unit Test PHP
Unit Test SQL
Related Topics
Guru’s Software Testing
Software Testing Tools – All free and Open-Source
Software Testing Techniques
Software Testing Techniques - II
Also Available
Server Virtualization – World’s Hottest Topic – A Good Research Work
If these topics really helped you or to make this topic more informative please give your suggestions/comments. Thanks
