SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
Schema compare tools
List of database schema compare and synchronization tools.
EMS DB Comparer for InterBase/Firebird
EMS DB Comparer for InterBase/Firebird is an excellent tool for InterBase/Firebird 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 InterBase/Firebird databases and eliminate all or selected differences.
| Runs on: (for desktop): | Windows |
|---|---|
| Schema sync: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
EMS DB Comparer for Oracle
EMS DB Comparer for Oracle is an excellent tool for Oracle database comparison and synchronization. With 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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Free |
| Free edition: |
|
DB Compare (discontinued)
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Free |
| Free edition: |
|
A7 SQL Tools
a7 SqlTools is a SQL management tools package with the functionality of searching, exploring and comparing the structure and data of databases.
| Runs on: (for desktop): | Windows |
|---|---|
| Schema sync: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Free |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
Apricot DB
Allows to compare the different snapshots and generates the diff script.
| Runs on: (for desktop): | Windows |
|---|---|
| Schema sync: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Free |
| Free edition: |
|
dbForge Schema Compare for Redshift/PostgreSQL
dbForge Schema Compare for Redshift/PostgreSQL is a tool for easy and effective comparison and deployment of Amazon Redshift database structure differences. The tool allows comparing two PostgreSQL database schemas, gives a comprehensive view of all differences in Amazon Redshift database schemas, and generates clear and accurate SQL synchronization scripts to update the database schemas.
| Runs on: (for desktop): | Windows |
|---|---|
| Schema sync: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Free |
| Free edition: |
|
