DB Sanity 0.9.4 released
2012-04-11
DB Sanity performs checks on a database for verifying data consistency and correctness of aplication deployments. It is invoked by command line and creates an HTML report with aggregated diagnostic summaries and listings of faulty database entries.
Version 0.9.4 brings major improvements:
- New check types:
- Supporting multi-column validators: <validator columns="bank_code, account_no" ... />
- <data> check: multicolumn-comparison with reference data sets (exact set/sub set/super set) in CSV or Excel(TM) files
- <trimmed> check: verify that strings do not start or end with whitespace
- <paths> check: Assure (in)equality of alternative foreign key paths from one table to another
- Reports
- Summary report in Excel(TM) format
- HTML Report files use UTF-8 encoding
- Other
- Improved performance of database meta data import and caching
- Supporting fallback version of dbsanity.xml in USER_HOME/databene/
All known bugs have been fixed
Read a detailed article about What's new in DB Sanity 0.9.4.
Read more about DB Sanity on the project page.


