Categories ▾
Data Modeling
Data Catalog Tools
Data Dictionary
Business Glossary
Data compare
Data democratization tools
Data discovery tools
Data Governance
Data intelligence tools
Data lineage tools
Data literacy tools
Data observability tools
Data Profiling tools
Database design
Diagram / RE
DB Documentation Generators
DB Documentation
Extended properties editors
GDPR compliance
GUI tools
Metadata Management
PL/SQL documentation
Reference Data Management tools
Schema Compare
Sensitive data discovery
SQL Lineage Tools
SQL Parsing Tools / SQL Parsers
SSAS documentation
SSIS documentation
Version Control
All categories
Databases ▾
SQL Server
Oracle
MySQL
PostgreSQL
Amazon Redshift
Azure SQL Database
DBT
Google Big Query
IBM DB2
MariaDB
SAP HANA
Snowflake
SQLite
Teradata
Vertica
All databases

Schema compare tools for SQL Server

List of database schema compare and synchronization tools.

Visual Studio - SQL Server Data Tools

https://www.visualstudio.com/vs/ssdt/

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
Go to vendor website

Red Gate SQL Compare

http://www.red-gate.com/products/sql-development/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
Go to vendor website

SQL Examiner

http://www.sqlaccessories.com/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
Go to vendor website

dbForge Schema Compare for SQL Server

https://www.devart.com/dbforge/sql/schemacompare/

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
Go to vendor website

SQL Admin Studio

https://sql-admin-studio.soft112.com/

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
Go to vendor website

DBComparer

http://dbcomparer.com/

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
Go to vendor website

SQL Delta Duo for SQL Server

https://sqldelta.com/products/SDSS

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
Go to vendor website

xSQL Schema Compare

http://www.xsql.com/products/sql_server_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
Go to vendor website

ApexSQL Diff

http://www.apexsql.com/sql_tools_diff.aspx

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
Go to vendor website

SQLDBDiff

http://sqldbtools.com/index.php?option=com_content&view=article&id=6:sqldbdiff-4-1&catid=8:sqldbdiff&Itemid=122

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
Go to vendor website

Quest Toad for SQL Server

https://www.quest.com/products/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
Go to vendor website

Idera DB Change Manager

https://www.idera.com/database-change-management

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
Go to vendor website

Aqua Data Studio Schema Compare Tool

https://www.aquafold.com/aquadatastudio/schema_sql_compare

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
Go to vendor website

SQL Server Comparision Tool

http://www.sql-server-tool.com/index.htm

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
Go to vendor website

Altova DatabaseSpy

https://www.altova.com/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
Go to vendor website
See more

Categories

Data modeling tools Data catalog tools Data dictionary tools Business Glossary tools Data compare tools Data democratization tools Data discovery tools Data Governance tools
All categories

Databases

SQL Server Oracle MySQL PostgreSQL
All databases
Want to add your tool or have a question? Contact us at contact@dbmstools.com
About us