Schema compare tools

List of database schema compare and synchronization tools.

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

AccdbMerge

AccdbMerge is an easy to use diff & merge tool for Microsoft Access *.accdb and *.mdb files. It has native two-panel UI that is commonly used in industry-leading text-diff tools. This tool allows users to compare and import/export database programming objects and data between any two database files.

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

KS DB Merge Tools for MySQL

KS DB Merge Tools for MySQL is an easy to use diff & merge tool for MySQL and MariaDB databases. 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

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

Oracle Data Compare

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

dbForge Studio for MySQL

dbForge Compare Bundle for Oracle consists of two tools: Schema Compare and Data Compare. They are designed to compare, synchronize, and analyze Oracle databases. It saves time by automating routine tasks and simplifies all comparison and sync operations with its many available options.

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