testdriven.com Wrangling quality out of chaos

Not properly-speaking a unit-testing tool, this is an Eclipse plugin for Oracle Developers and Admins, loaded with features to ease database management.
link

DbFit is an extension of .Net2 FIT test runner which enables FIT/FitNesse tests to execute directly against a database. Supports testing stored procedures and functions, executing queries and statements on Oracle. Support for SqlServer is currently in development.
link

SQL Refactor allows you to automatically format your SQL code and database objects in the style of your choice. SQL Refactor improves the quality of your code, making it easier to read, understand and share amongst a team. A companion tool to SQL Prompt, SQL Refactor dramatically speeds up database development and administration, without impacting on the behavior of your database and applications.

(Commercial tool)
link

Marjoree is a Ruby library that allows easy scripting and test access to a database, making it ideal for test-driving stored procedures.

link

Quest Code Tester is a revolutionary new tool in the Oracle space that automates the process of creating and running tests on PL/SQL program units. With Quest Code Tester, forget about writing test code. Instead you describe your test requirements through an intuitive user interface, and then the tool:

* Stores this information in a repository, providing a rich reporting database.
* Generates test code (a PL/SQL package).
* Runs your tests.
* Automatically reports the results.

Quest Code Tester for Oracle is now available for download and use without any licensing fee. This release expires at the end of February 2007, at which time commercial, trial and freeware versions will be available.
link

The MassDataHandler is a framework to assist with Database Unit Testing. The framework makes it very easy to insert test data into a database, which in turn makes it very easy to write database unit tests. The user merely needs to specify their relevant data in a simple XML fragment, and then the framework uses knowledge of the database schema to do all the grunt work and convert that XML data into SQL, from which it populates the database.

The XML fragments that contain the test data are robust and refactorable. You can include expressions like variables substitution and identity lookup, default row templates, and include statements to import sub-templates. Because the framework already knows the database schema, you only need to specify the relevant data, and the framework can auto-populate the rest of the row’s required columns with dummy data.

This tool is intended for:

* Supplying data for Database unit testing.
* Easily creating your own data script to insert data for development.
* Extracting data from one database and inserting it into another as test data.
* Getting snapshots of data, and them converting them to xml files for easy diff comparisons.
link

Entropy’s dataFresh is a toolkit that assists test driven development projects in restoring their database to a known state before each test within a test fixture. The time consuming effort of having to write tear down methods to clean up the database after running your tests are a thing of the past.

Our appoach is unlike others as we do not attempt to rip and replace the entire database. Instead we track database modifications to the table level and only work with those tables that have been modified.
link

NDbUnit is a .NET library for putting a database into a known state. NDbUnit may be used to increase repeatability in unit tests that interact with a database by ensuring that the database’s state is consistent across execution of tests. NDbUnit does this by allowing the unit test to perform an operation on a dataset before or after the execution of a test, thus ensuring a consistent state.
link

JDBC unit is a tool that plugs a recorder in the Java/JDBC framework. It records and plays back SQL statements sent to the database manager.

This tool permits usage of data that is not anymore, or never was, in the database, and writing code without a connection to the database.
link

Java library to speed up the running of automated tests for projects that use toplink to access databases. It allows you to run the application in memory, rather than against a database.
link

Thycotic.DatabaseScripter is a simple utility that generates a stored procedure called "SETUP" which will remove all data from your database and then reinsert it in the correct order. It uses the system tables in the database to identify foreign key dependencies and make sure data is manipulated int he appropriate manner.
link

Codus is a comprehensive code generation tool for object-relational mapping. It takes an existing database and automatically generates all of the code for updating, deleting, inserting and selecting records. In addition, it creates web services for distributed programming, strongly-typed collections, and a full set of NUnit tests.
link

A java framework for extreme development of database systems. The framework is based on the theory of self-describing objects that allow separation of ‘what’ from the ‘what with’ (e.g. ‘search form’ for ‘client’).
link

SQLUnit is a regression and unit testing harness for testing database stored procedures. A 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.
link

TestFu is a collection of frameworks to build data generator, state machines, grammars, etc… It includes:
- the Production Grammar Framework (rule-based generic generators)
- the Database Populator Framework (smart random-data generators to populate databases)

TestFu has been separated from MbUnit to allow any user to benefit from those two frameworks without having to use MbUnit itself.

Note: TestFu is now part of the testdriven.net package.
link

DBMonster is a tool which generates random test data and puts it into SQL database. It helps to test how an application can deal with large database.
link

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.
link

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.
link

DbUnit is a JUnit extension (also usable from Ant) targeted for database-driven projects that, among other things, puts your database into a known state between test runs. This is an excellent way to avoid the myriad of problems that can occur when one test case corrupts the database and causes subsequent tests to fail or exacerbate the damage.

DbUnit has the ability to export and import your database (or specified tables) content to and from XML datasets. This is targeted for functional testing, so this is not the perfect tool to backup a huge production database.

DbUnit also provides assert facility to verify that your database content match some expected values.
link