Schema compare tools
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: |
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: | |
Data compare: | |
Data sync: | |
Commercial: | Commercial |
Free edition: |
SQL Admin Studio
SQL Admin Studio is a complete database management and design environment for SQL Server, MSDE, Express, Access, and MySQL. It features schema explorer, backup and restore, query designer, full display script editor with syntax highlighting, Intellisense, table designer, code templates, indexes, constraints, and foreign keys.
Runs on: (for desktop): | Windows |
---|---|
Schema sync: | |
Data compare: | |
Data sync: | |
Commercial: | Free |
Free edition: |
DBComparer
DBComparer provides a clean and straight-forward user interface. It automates database comparison and compares all database objects or selected ones only.
Runs on: (for desktop): | Windows |
---|---|
Schema sync: | |
Data compare: | |
Data sync: | |
Commercial: | Free |
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: |
SQL Delta Duo for MySQL
SQL Delta for MySQL is a tool for comparing and synchronizing schema and data of two MySQL databases side by side.
Runs on: (for desktop): | Windows |
---|---|
Schema sync: | |
Data compare: | |
Data sync: | |
Commercial: | Commercial |
Free edition: |
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: | |
Data compare: | |
Data sync: | |
Commercial: | Commercial |
Free edition: |
xSQL Schema Compare
xSQL Schema Compare tool compares the schemas of two SQL Server databases, review differences, generate synchronization script and execute it. It provides fast, effortless and safe SQL Server database schema compare and synchronization.
Runs on: (for desktop): | Windows |
---|---|
Schema sync: | |
Data compare: | |
Data sync: | |
Commercial: | Commercial |
Free edition: |
ApexSQL Diff
ApexSQL Diff compares SQL schemas from databases, backups, scripts and source control. It deploys a database directly from the source control and initiate database compares directly from SSMS.
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: |
Quest Toad for SQL Server
Quest Toad for SQL Server is a tool that compares and synchronizes schema and data of the SQL Server databases. It easily identifies differences by comparing and syncing servers, schemas, and data and enables a number of scripts to be executed against different servers at the same time.
Runs on: (for desktop): | Windows |
---|---|
Schema sync: | |
Data compare: | |
Data sync: | |
Commercial: | Commercial |
Free edition: |
Quest Toad Egde
Quest Toad Edge is a lightweight, reliable desktop toolset that simplifies the development and management of open-source relational databases, such as MySQL and PostgreSQL. Toad Edge makes it easy for you to ramp-up quickly, with support for coding, editing, and schema compare and sync.
Runs on: (for desktop): | Windows |
---|---|
Schema sync: | |
Data compare: | |
Data sync: | |
Commercial: | Commercial |
Free edition: |