Schema compare tools

List of database schema compare and synchronization tools.

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

Database Comparer Tools

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 SQL Server

EMS DB Comparer for SQL Server is an excellent tool for SQL Server 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 SQL Server 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

MssqlMerge

MssqlMerge is an easy to use diff & merge tool for Microsoft SQL Server databases. This tool allows to compare and import/export database objects and data between two databases.

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

Open DBDiff

Open DBDiff is a database comparison tool for Microsoft SQL Server 2005+ that reports schema differences and creates a synchronization script.

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

DB Compare

DB Compare is a simple utility that compares the schema (Tables, Views, and Stored Procedures) of two SQL Server databases.

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

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

Visual Expert for SQL Server

Visual Expert for SQL Server provides solution for the maintenance of your SQL Server Code. It provides application-wide comparisons, not only for a file or an object. Comparisons are based on the code structure, allowing to find differences for a given object, or object category, such as procedures, tables, triggers, etc.

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

DB Ghost Change Manager

DB Ghost provides flexible tools for source scripting, building, comparing, synchronizing, creating delta scripts, upgrading and packaged remote delivery. Compare can also produce Delta scripts between database.

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

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