DB Sanity performs checks on a database for verifying data consistency and correctness of aplication deployments. It is invoked by the command line and creates an HTML report with a summary and listings of faulty database entries.
| Tags | Database verification sanity check Reports Testing data analysis |
|---|---|
| Licenses | GPLv2 |
| Operating Systems | Windows Mac OS X Linux Solaris HP-UX |
| Implementation | Java HTML SQL jdbc |
Recent releases


Release Notes: This is a bugfix release. In CSV files, null values and empty strings are now recognized correctly. In HTML reports, relative paths are used.


Release Notes: This release adds several new checking features: multi-column validator support, multicolumn-validation against reference data sets (exact set/sub set/super set) in CSV or Excel(TM) files, trim checking, and verification of alternative foreign key paths between two tables. All known bugs have been fixed.


Release Notes: Tag clouds show at a glance which checks were executed and which where the most defective ones. A hierarchy provider interface allows for custom definition of hierarchical grouping mechanisms; one provided implementation uses checks to specify tree paths. DatabeneScript expressions can be used to employ a subset of the Java syntax for instantiating plugins. The InfoModule provides more extensive information, and all known bugs were fixed.


Release Notes: This release provides some minor bugfixes in report rendering and navigation. Copying reports with long nested structures is made less problematic by reducing the length of the report file paths. During check execution, the user gets feedback about the number of completed and pending checks.


Release Notes: The new version adds more predefined check types which can be used to verify database tables without SQL knowledge, custom Java validator classes which can be plugged in to perform more sophisticated client-side (or cross-system) checking. Existing functionality has been undergone additional testing, stabilization, and simplification.