Schema compare tools

List of database schema compare and synchronization tools.

dbForge Schema Compare for MySQL

dbForge Schema Compare for MySQL is a tool for easy and effective comparison and deployment of MySQL database structure diffs. The tool gives a comprehensive view of all differences in MySQL database schemas and generates clear and accurate SQL synchronization scripts.

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

JuxtAPPose

JuxtAppose is a data comparison tool that allows you to load a spreadsheet and/or connect to a DB, run a query, and get the data to compare. You can display only the rows with differences and use colors to identify the problems.

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

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

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