A generic SQL driven data audit tool for detecting differences between any JDBC accessible database tables and other data sources. Platform independent. It's a unix like diff for databases. Produces key values with the differing column name and data
Features
- Driven by SQL statements or a delimited flat file
- Supports unload SQL syntaxes of DB2, SQLserver and Informix.
- Allows sets of preparatory SQL statements
- Implements Source Target nested loop paradigm with optional reverse compare option.
- Intelligent date format guessing and standard big number handling drastically reduces false positives
- Java and JDBC, platform and database independence.
- Specialises in dates, numbers and strings
- Produces spreadsheet readable output
License
GNU General Public License version 2.0 (GPLv2)Follow Compare Database Table Data
You Might Also Like
Venn is a secure workspace for remote work that isolates and protects work from any personal use on the same computer. Work lives in a secure local enclave that is company controlled, where all data is encrypted and access is managed. Within the enclave – visually indicated by the Blue Border around these applications – business activity is walled off from anything that happens on the personal side. As a result, work and personal uses can now safely coexist on the same computer.
Rate This Project
Login To Rate This Project
User Reviews
There are no 3 star reviews.