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

Ship Agents Faster

Transform your applications and workflows into powerful agentic systems at global scale.

Gemini Enterprise Agent Platform lets you rapidly build, scale, govern and optimize production-ready agents grounded in your organization's data. The platform enables developers to build custom or pre-built agents for virtually any use case. New customers get $300 in free credits.

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
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
PBRS Power BI Reports Distribution

PBRS (Power BI Report Scheduler) by ChristianSteven Software automates report scheduling, export, personalization and delivery across Power BI Service, Power BI Report Server, Power BI Paginated Reports and Microsoft SSRS. Designed for BI teams, IT departments and organizations with recurring...

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

Report inappropriate content