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 Oracle

dbForge Schema Compare for Oracle is a comprehensive tool for database schema comparison and synchronization. This Oracle comparison tool helps to identify the impact of changes made to your database schema, as it easily points out all differences and allows generating customized Oracle schema synchronization script.

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

SQL Delta Duo for Oracle

SQL Delta for Oracle compares two Oracle databases side by side in two separate tabs. It provides comprehensive search and filtering of compare results, filter schema load, two-click synchronize and report on compare.

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

Quest Toad for Oracle

Quest Toad for Oracle is a tool that compares and synchronizes schema and data of the Oracle databases. It automates complex and repetitive tasks like schema compare, script execution, administration, reporting and more.

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

Idera DB Change Manager

DB Change Manager tracks and manages complex database schema changes and complies with database audit and reporting requirements. It protects data privacy within the database environment and track changes from multiple major database platforms.

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

EMS DB Comparer for Oracle

EMS DB Comparer for Oracle is an excellent tool for Oracle database comparison and synchronization. Having EMS DB Comparer for Oracle you can work with several projects at once, define Oracle comparison parameters, print difference reports, and alter modification 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

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 Oracle

Visual Expert for Oracle is a must-have solution for the maintenance of your Oracle code. It provides code comparisons that 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

PostgresCompare

PostgresCompare compares PostgreSQL database schema objects and generates the SQL to deploy the differences. An accurate and easy to use schema diff tool for Postgres.

Runs on: (for desktop): Linux,Mac OS,Windows
Schema sync: Yes
Data compare: No
Data sync: No
Commercial: Commercial
Free edition: No
PostgresCompare Comparisons
PostgresCompare Diff
PostgresCompare Script