Compare Database Table Data download

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

Terminal or Consol screen output of command line run

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

$300 Free Credits to Build on Google Cloud

New customers can spin up VMs, build with AI, and query data at no cost.

Put your $300 in credit toward real workloads, then keep building with free monthly usage for 20+ products. No commitment and no charge until you upgrade.

Start Free

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

Similar Business Software

DbVisualizer

DbVisualizer is a universal database client for anyone who works with data, from solo developers and startups to professional teams managing complex environments, including developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It offers a graphical interface...

See Software
Windocks

Windocks is a leader in cloud native database DevOps, recognized by Gartner as a Cool Vendor, and as an innovator by Bloor research in Test Data Management. Novartis, DriveTime, American Family Insurance, and other enterprises rely on Windocks for on-demand database environments for development,...

See Software
Google Cloud SQL

Fully managed relational database service for MySQL, PostgreSQL, and SQL Server with rich extension collections, configuration flags, and developer ecosystems. New customers get $300 in free credits to spend on Cloud SQL. You won’t be charged until you upgrade. Reduce maintenance costs with...

See Software
Google Cloud BigQuery

BigQuery is a serverless, multicloud data warehouse that simplifies the process of working with all types of data so you can focus on getting valuable business insights quickly. At the core of Google’s data cloud, BigQuery allows you to simplify data integration, cost effectively and securely...

See Software
SmartDraw

SmartDraw makes professional drawings and diagrams accessible to everyone. Non-technical users can quickly create floor plans, while professionals get the precision and scale they require. With industry-leading floor planning tools and an intuitive interface for traditional diagramming like...

See Software
StackAI

StackAI is an enterprise AI automation platform to build end-to-end internal tools and processes with AI agents in a fully compliant and secure way. Designed for large, regulated organizations, it enables teams to automate complex workflows across operations, compliance, finance, IT, and support...

See Software