DB Sanity performs checks on a database for verifying data consistency and correctness of application deployments or production data. It is invoked by the command line and creates an HTML report with a summary and listings of faulty database entries.

The Summary page gives you an overview over all test results:

Each sub folder is interpreted as a test group and has its own summary page. This way, you can recursively drill down through a hierarchy of validity checks.

For each failure, a defects page displays the SQL query and the faulty database table rows:

There is a comple list of report modules.

Supported systems

DB Sanity is supposed to work on

- any system that supports Java 6 or newer, e.g. Windows XP, Vista, 7, Mac OS X, Linux, HP-UX, Solaris

- with any database for which a JDBC driver exists, e.g. Oracle, DB2, MS SQL Server, MySQL, HSQL, H2, Derby, Firebird

- with any web browser, e.g. Frefox, Internet Explorer, Chrome, Safari

QA Process

Each release of DB Sanity is tested

- with Java 6 on Windows XP and Mac OS X

- on Oracle and HSQL databases

- with Mozilla Firefox, Internet Explorer, Safari and Chrome

Potential contributors are welcome to run DB Sanity on other systems and report success and problems!

Further Information

Documentation

• Report Modules
• So, what to check with DB Sanity?
• Getting Started
• File Syntax
• Command Line Arguments
• Environment Files
• What's new in DB Sanity 0.9.0
• FAQ
• Developer Documentation

Important Addresses

• Project Home Page
• Forum
• Feature Request Tracker
• Bug Tracker

Developers and Contributors

Release History