About

CompareData is a cross-dbms Windows application that allows you to visually compare and synchronize data between sql databases.

You can compare table, view or query data to see differences highlighted on the screen. You can also compare table meta-data, generate sql sync scripts and use the command line and internal scheduling to automate comparisons and data synchronization.

Features

• Compare data of a table, query or group of tables with one command.
• Synchronize table data at row level, table level or group level.
• Compare resultsets of any size.
• Compare meta-data for a table or group of tables, including primary key, columns, indices, foreign keys, triggers, permission and check constraints.
• Compare stored procedures/functions and sequences.
• Native 64-bit application.
• Multi-threaded, multi-core support.
• Free for comparing table and view data.

For

Database data comparison, migration and synchronization. Snapshot replication, replication verification and trouble-shooting. ETL, before-and-after QA.

Works with

DB2, BigQuery, Firebird, Informix, Ingres, InterBase, MariaDB, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Redshift, SAP Adaptive Server, SAP SQL Anywhere, Snowflake, SQLite.
Microsoft Access, Excel and any sql dbms with ODBC connectivity.

Requires

• Windows 10
• ODBC 3.5 drivers