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 Azure SQL Database
List of database schema compare and synchronization tools.
Visual Studio - SQL Server Data Tools
SQL Server Data Tools for Visual Studio enables you to analyze and compare database schema and data and apply changes on the target database or to generate T-SQL scripts to run later. Data comparison compares data between two existing databases of the same schema and can write the script to apply the changes.
| Runs on: (for desktop): | Windows |
|---|---|
| Schema sync: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
Red Gate SQL Compare
SQL Compare is an industry-standard tool for comparing and deploying SQL Server database schemas. It enables you to find and fix errors, and create deployment scripts in minutes.
| Runs on: (for desktop): | Windows |
|---|---|
| Schema sync: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
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: |
|
dbForge Schema Compare for SQL Server
dbForge Schema Compare for SQL Server is a powerful, fast and easy-to-use schema comparison tool for SQL Server. It allows you to work with live SQL Server databases, snapshots, script folders and native backups.
| Runs on: (for desktop): | Windows |
|---|---|
| Schema sync: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
SQL Delta Duo for SQL Server
SQL Delta for SQL Server runs two or more projects side by side in separate tabs, whether it's two schema compare projects on completely separate servers or a schema compare and data compare project on the same server. It shows an overview of all the objects that are different or not in either the source or target. By selecting each object you can see at the schema level the various differences.
| Runs on: (for desktop): | Windows |
|---|---|
| Schema sync: |
|
| Data compare: |
|
| Data sync: |
|
| Commercial: | Commercial |
| Free edition: |
|
SQLDBDiff
SQLDBDiff is a powerful and intuitive tool that compares the schema and the data of SQL Server databases. It enables you to compare many databases to the same master database. You can also compare tables even if they have different schemas or the primary key is missing.
| 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: |
|
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: |
|
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: |
|
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: |
|
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: |
|
