Schema compare tools

List of database schema compare and synchronization tools.

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

Database Workbench

Database Workbench provides database comparison where you can compare development with production databases and get a change script. You can also compare databases even across different database systems, with automatic data type and default function mapping.

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

Data Compare for Oracle

Data Compare for Oracle allows you to compare and synchronize data from two Oracle databases. It compares both tables and views, supports simple and complex data types, handles large data sets quickly and efficiently, supports variable transaction size, and includes a command line utility for scheduled, unattended comparison and synchronization sessions.

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