Schema compare tools for SQL Server

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

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

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: 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

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

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

Aqua Data Studio Schema Compare Tool

Aqua Data Studio Schema Compare Tool allows you to quickly compare and safely synchronize databases for SQL Server or Oracle database. It detects and repairs unwanted database changes by comparing to backups and snapshots.

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

SQL Server Comparision Tool

SQL Server Comparison Tool analyzes, compares, and documents the structure of tables, procedures, functions, views, triggers, and relationships. It compares data stored in tables and generate detailed reports displaying results of comparisons or analysis.

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

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