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 for PostgreSQL
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
EMS DB Comparer for PostgreSQL
EMS DB Comparer for PostgreSQL is an excellent tool for PostgreSQL database comparison and synchronization. The program has the ability to automate the PostgreSQL database schemas comparison and synchronization task using the helpful Console Application.
| Runs on: (for desktop): | Windows |
|---|---|
| Schema sync: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| 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: |
|
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: |
|
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: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
