About
CompareData allows you to visually compare and synchronize data between sql databases.
Compare table, view or query data and see differences highlighted on the screen. Compare table metadata, generate sql sync script, use the command line and internal scheduling to automate comparison and data synchronization.
Features
- Compare data of table, query or group of tables.
- Synchronize table data at row, table or group level.
- Compare table metadata including columns, primary key, indices, foreign keys, triggers, permission and check constraints.
- Compare stored procedures, functions and sequences.
- Cross-dbms support with ODBC.
- Compare resultsets of any size.
- Native 64-bit application.
- Multi-threaded, multi-core support.
- Free for comparing data and metadata.
For
Database data comparison, migration and synchronization. Snapshot replication, replication verification and trouble-shooting. ETL, before-and-after QA.
Works with
Db2, BigQuery, Cosmos DB, Firebird, Informix, InterBase, MariaDB, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Amazon Redshift, SAP Adaptive Server, SAP HANA, SAP SQL Anywhere, Snowflake, SQLite, Teradata, TiDB, YugabyteDB and more.
Microsoft Access, Excel, Airtable, Google Sheets and any data source with ODBC connectivity.
Requires
- Windows 10, 11 or Windows Server*
- ODBC drivers