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: Yes
Data compare: Yes
Data sync: No
Commercial: Commercial
Free edition: Yes

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: Yes
Data compare: No
Data sync: No
Commercial: Commercial
Free edition: No

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: Yes
Data compare: No
Data sync: No
Commercial: Commercial
Free edition: No

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: Yes
Data compare: No
Data sync: No
Commercial: Commercial
Free edition: No

dbForge Schema Compare for MySQL

dbForge Schema Compare for MySQL is a tool for easy and effective comparison and deployment of MySQL database structure diffs. The tool gives a comprehensive view of all differences in MySQL database schemas and generates clear and accurate SQL synchronization scripts.

Runs on: (for desktop): Windows
Schema sync: Yes
Data compare: No
Data sync: No
Commercial: Commercial
Free edition: No

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: Yes
Data compare: No
Data sync: No
Commercial: Commercial
Free edition: No

SQL Admin Studio

SQL Admin Studio is a complete Database Management & Design Environment for SQL Server, MSDE, Express, Access & 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: Yes
Data compare: Yes
Data sync: Yes
Commercial: Free
Free edition: Yes

DBComparer

DBComparer is a professional database comparison tool for analyzing the differences in Microsoft SQL Server 2008 (and 2005) database structures.

Runs on: (for desktop): Windows
Schema sync: No
Data compare: No
Data sync: No
Commercial: Free
Free edition: Yes

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: Yes
Data compare: Yes
Data sync: Yes
Commercial: Commercial
Free edition: No

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: Yes
Data compare: Yes
Data sync: Yes
Commercial: Commercial
Free edition: No

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: Yes
Data compare: Yes
Data sync: Yes
Commercial: Commercial
Free edition: No

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: Yes
Data compare: No
Data sync: No
Commercial: Commercial
Free edition: Yes

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: Yes
Data compare: No
Data sync: No
Commercial: Commercial
Free edition: No

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: Yes
Data compare: No
Data sync: No
Commercial: Commercial
Free edition: Yes

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: Yes
Data compare: Yes
Data sync: Yes
Commercial: Commercial
Free edition: No