Schema compare tools

List of database schema compare and synchronization tools.

SQL Examiner

SQL Examiner compares and synchronizes the schemas of the databases. It speeds up the deployment of schema updates and quickly compares databases and find all the differences.

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

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

SQL Delta Duo for MySQL

SQL Delta for MySQL is a tool for comparing and synchronizing schema and data of two MySQL databases side by side.

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

Quest Toad Egde

Quest Toad Edge is a lightweight, reliable desktop toolset that simplifies the development and management of open-source relational databases, such as MySQL and PostgreSQL. Toad Edge makes it easy for you to ramp-up quickly, with support for coding, editing and schema compare and sync.

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

Database Comparer Standalone Utility

Database Comparer helps to compare, synchronize and update databases structure using highly intelligent and robust synchronization algorithm. You can compare one database with another database or database with SQL/DDL script or even two SQL/DDL scripts.

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

Datanamic SchemaDiff MultiDB

Datanamic SchemaDiff is a tool for comparison and synchronization of database schemas. It allows you to compare and synchronize tables, views, functions, sequences (generators), stored procedures, triggers and constraints between two databases.

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

Nob Hill Database Compare

Nob Hill Database Compare tool performs database comparison both schema and data. With the context-free database scripting engine, you can generate a script that could be run on any database. It will tell you the differences, and change any database to be like the one you are scripting - both schema and data.

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

EMS DB Comparer for MySQL

EMS DB Comparer for MySQL is an excellent tool for MySQL database comparison and synchronization. It allows you to view all the differences in compared database objects and execute an automatically generated script to synchronize structure of MySQL databases and eliminate all or selected differences.

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

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