SQL Compare versions

Compare backup and source control databases
Jan 18, 2024
Apr 16, 2021
Review
Jan 19, 2020
Review
Mar 19, 2018
Review
May 16, 2016
Review
Feb 17, 2016
Dec 10, 2015
Review
Sep 13, 2015
Review
May 14, 2015
Review
Nov 30, 2014
Review
Sep 27, 2014
Review
May 2, 2014
Review
Jun 6, 2013
Review
Mar 21, 2013
Review
Jun 1, 2012
Review
Mar 19, 2012
Dec 19, 2011
Review
9.0
Nov 7, 2010
Review
8.2
May 13, 2010
8.1
Jul 25, 2009
8.0
Jan 28, 2009
7.1
Oct 10, 2008
7.0
Sep 1, 2008
6.2
Mar 1, 2008

What's new

v14.5 [Apr 16, 2021]
Fixes
- ZD-250030: Turning off system versioning on a table that is consumed by a security policy no longer results in an incorrect deployment script
- ZD-251196: Fixed a bug in deployment scripts using CURRENT_USER
- ZD-251135: STATISTICS_NORECOMPUTE=ON is no longer scripted out for columnstore indexes; instead sp.autostats is invoked

v13.8 [Jan 19, 2020]
Fixes:
- SC-10625 - CONCAT_WS is now recognised as a system function on SQL Server 2017 and above.
- SC-10644 - The 'drop and create instead of alter' option has been renamed 'use drop and create for rerunnable scripts' and had the 'drop and create instead of create' functionality restored. It still only works on some object types, which are listed in the option description.
- SC-10641 - text objects (e.g. stored procedures) that reference system queues no longer cause a crash in dependency processing.
- SC-10630 - WITH CHANGE_TRACKING_CONTEXT with a literal parameter (as opposed to a variable) no longer causes a parsing error when registering from a scripts folder.

v11.6 [May 16, 2016]
Fixes
SQL Compare XML Report no longer includes an attribute of 'areidentical'.
SC-8524: support hardware crypto devices (e.g. nCipher) for asymmetric key encryption
SC-8482: SQL Compare now correctly adds columns to pre-existing Full Text Indexes when transactions are disabled.

v11.4 [Dec 10, 2015]
64-bit support, Azure v12 support, & SQL Server 2016 connectivity
Option to use server or database compatibility level to detect supported features
Compare & deploy security policy objects and columnstore indexes on in-memory tables in SQL Sever 2016 CTP2
Compare & deploy masked columns in Azure v12 and SQL Server 2016 CTP2.3
Compare & deploy stretched tables in SQL Server 2016 CTP2.3
Bug fixes.

v11.3 [Sep 13, 2015]
May include unspecified updates, enhancements, or bug fixes.

Alternative downloads

Devart Code Compare
Devart Code Compare
rating

Free file and folder diff & merge tool, Visual Studio integrated.

Data Compare for Oracle
Data Compare for Oracle
rating

It can compare Oracle tables and deploy differences.

MySQL Compare
MySQL Compare
rating

Allows you to compare and synchronize the schemas of MySQL databases

Data Sync for MySQL
Data Sync for MySQL
rating

Powerful tool for comparison of database contents.

Devart dbForge Data Compare for PostgreSQL
Devart dbForge Data Compare
rating

A tool for table data comparison and synchronization.