Schema compare tools

List of database schema compare and synchronization tools.

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

ERBuilder Data Modeler

ERBuilder Data Modeler allows developers to graphically design databases by using entity relationship diagrams, and automatically generates the most popular SQL databases. It also allows developers to easily deploy databases by offering a sophisticated visual data modeling environment.

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

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

KS DB Merge Tools for SQLite

KS DB Merge Tools for SQLite is an easy to use diff & merge tool for SQLite database files. It has native two-panel UI that is commonly used in industry-leading text-diff tools. This tool allows users to compare database object definitions and data, generate and execute SQL scripts to synchronize these changes.

Runs on: (for desktop): Windows
Schema sync: Yes
Data compare: Yes
Data sync: Yes
Commercial: Commercial
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