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 IBM DB2
List of database schema compare and synchronization tools.
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: |
|
| 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: |
|
UDB Workbench
UDB Workbench is a tool for DB2 UDB LUW database comparison and synchronization. It allows you connect DB2 UDB databases through ODBC or through schema DDL file, and view all the differences between two connected sources, and execute synchronization script that generated by the tool to synchronize structure of your DB2 UDB databases.
| 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: |
|
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: |
|
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: |
|
