Overview

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

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

Features

• Compare data of a group of tables or queries with one command
• Synchronize table data at row level, table level or group level
• Compare resultsets of any size. See comparing large resultsets
• Compare schema for two tables or a group of tables including: columns, indices, primary key, foreign keys, triggers, table permissions and check constraints
• Compare stored procedures/functions and sequences
• Multi-threaded, multicore-support design. Native 64-bit application. See x64
• Free for comparing table or view data

Uses

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

DBMS Support

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.

Requirements

• Windows XP SP3 or higher
• ODBC 3.5 compliant drivers