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 for Your Google Cloud Projects

Start building on Google Cloud with $300 in free credits. No commitment, no credit card required until you're ready to scale.

Launch your next project with $300 in free Google Cloud credits—no strings attached. Test, build, and deploy without risk. Use your credits across the entire Google Cloud platform to find what works best for your needs. After your credits are used, continue with always-free tier services. Only pay when you're ready to scale. Sign up in minutes and start exploring.

Start Free Trial

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