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

Project Samples

Project Activity

See All Activity >

License

GNU General Public License version 2.0 (GPLv2)

Follow Compare Database Table Data

Compare Database Table Data Web Site

Other Useful Business Software
Custom VMs From 1 to 96 vCPUs With 99.95% Uptime Icon
Custom VMs From 1 to 96 vCPUs With 99.95% Uptime

General-purpose, compute-optimized, or GPU/TPU-accelerated. Built to your exact specs.

Live migration and automatic failover keep workloads online through maintenance. One free e2-micro VM every month.
Try Free
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of Compare Database Table Data!

Additional Project Details

Intended Audience

Advanced End Users, Developers, Information Technology, Quality Engineers, System Administrators

User Interface

Command-line

Programming Language

Java

Database Environment

JDBC, Project is a database management tool, SQL-based

Related Categories

Java Data Warehousing Software, Java QA Automation Software, Java Business Intelligence Software

Registered

2008-05-30