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

Forever Free Full-Stack Observability | Grafana Cloud

Our generous forever free tier includes the full platform, including the AI Assistant, for 3 users with 10k metrics, 50GB logs, and 50GB traces.

Built on open standards like Prometheus and OpenTelemetry, Grafana Cloud includes Kubernetes Monitoring, Application Observability, Incident Response, plus the AI-powered Grafana Assistant. Get started with our generous free tier today.

Create free account

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 developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It provides a graphical interface for database development, SQL querying, data exploration, and database admin. The tool includes a powerful SQL editor...

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
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 organizations, it enables teams to automate complex workflows across operations, compliance, finance, IT, and support without...

See Software
Highcharts

Highcharts is a JavaScript charting library that allows developers to create interactive and visually appealing charts for web applications. It offers a wide range of chart types, including line charts, bar charts, pie charts, scatter plots, and more. It also supports different types of data,...

See Software