Schema compare tools

List of database schema compare and synchronization tools.

Idera DB Change Manager

DB Change Manager tracks and manages complex database schema changes and complies with database audit and reporting requirements. It protects data privacy within the database environment and track changes from multiple major database platforms.

Runs on: (for desktop): Windows
Schema sync: Yes
Data compare: Yes
Data sync: Yes
Commercial: Commercial
Free edition: No

Altova DatabaseSpy

Altova DatabaseSpy is the unique multi-database query, design, and database comparison tool that even generates elegant charts directly from query results.

Runs on: (for desktop): Windows
Schema sync: Yes
Data compare: Yes
Data sync: Yes
Commercial: Commercial
Free edition: No

Altova DiffDog

Altova DiffDog is a database content comparison and schema diff/merge tool. It allows you to diff databases of the same type as well as the content of equivalent tables and entire database schemas in different database types.

Runs on: (for desktop): Windows
Schema sync: Yes
Data compare: Yes
Data sync: Yes
Commercial: Commercial
Free edition: No

UDB Workbench

UDB Workbench is a tool for DB2 UDB LUW database comparison and synchronization. It allows you connect DB2 UDB databases through ODBC or through schema DDL file, and view all the differences between two connected sources, and execute synchronization script that generated by the tool to synchronize structure of your DB2 UDB databases.

Runs on: (for desktop): Windows
Schema sync: Yes
Data compare: Yes
Data sync: Yes
Commercial: Commercial
Free edition: No

DB Best Database Compare Suite

DB Best Database Compare Suite compares database schemas and identifies differences in tables, views, triggers, stored procedures, functions, packages, synonyms, rules, etc. It also compares data in two database tables or views to quickly discover whether they are equal or not.

Runs on: (for desktop): Windows
Schema sync: Yes
Data compare: Yes
Data sync: Yes
Commercial: Commercial
Free edition: No

PostgresCompare

PostgresCompare compares PostgreSQL database schema objects and generates the SQL to deploy the differences. An accurate and easy to use schema diff tool for Postgres.

Runs on: (for desktop): Linux,Mac OS,Windows
Schema sync: Yes
Data compare: No
Data sync: No
Commercial: Commercial
Free edition: No
PostgresCompare Comparisons
PostgresCompare Diff
PostgresCompare Script

Apricot DB

Allows to compare the different snapshots and generates the diff script.

Runs on: (for desktop): Windows
Schema sync: Yes
Data compare: No
Data sync: No
Commercial: Free
Free edition: Yes

jOOQ

jOOQ schema diff is an online version of jOOQ's programmatic or CLI schema diff tool, allowing for quickly generating the necessary DDL scripts to get from one version of a schema to another.

Runs on: (for desktop): -
Schema sync: Yes
Data compare: No
Data sync: No
Commercial: Commercial
Free edition: Yes