CompareData is a Windows® cross-dbms application that
allows you to visually compare and synchronize data between two SQL databases
using ODBC drivers. You can retrieve some or all data for a table or view from
two databases and compare the data visually to see differences highlighted on
the screen. You can also compare data of two sql queries and dbms
Compare data between two tables or views of the same or different names
Compare columns having the same or different names and/or data types
Compare data of two sql queries
Synchronize table data at row level, table level or group level
Compare data of a group of tables and queries or all tables with
Compare resultsets of any size. See comparing large
Compare schema for two tables or a group of tables including: columns,
indices, primary key, foreign keys, triggers and table permissions
Compare stored procedures/functions
- Command line or internally schedule comparisons and data synchronization
- Multi-threaded, multicore-support design. Native 64-bit application. See x64
- Free for comparing table or view data
Database data comparison, migration, refresh and synchronization; snapshot replication, replication
verification and trouble-shooting; before-and-after process QA.
DB2, Firebird, Informix, Ingres, Microsoft SQL Server, MySQL, Oracle,
PostgreSQL, SQLite, Sybase Adaptive Server Enterprise, SQL Anywhere.
Basic support for Microsoft Access, Microsoft Excel, Pervasive PSQL, Teradata,
etc. See DBMS Notes.
Windows XP SP3 or higher
ODBC 3.5 compliant drivers to connect to the
databases you want compare their data or a compliant ODBC-JDBC
gateway and JDBC driver.