Data Compare for SQL Server- version 11

Data Compare for SQL Server allows you to compare and synchronize data in SQL Server databases. You can use it for data migration, auditing, replication verification, populating development databases with production data etc.

Data Compare supports SQL Server 2000 to 2019, Azure SQL Database and it is available for FREE as a fully functional Lite Edition (see the "Editions" below).

For a list of the new and improved features included in the version 11 of the data comparison, click here.

Release date: January 13, 2020.
Release date: December 02, 2019.
  • Adds support for Azure Active Directory Authentication.
  • Includes a new Data Differences Reports.
  • Supports the new graph tables and the edge constraints.
  • Adds a new option that synchronizes data changes with inserts/deletes instead of updates.
  • Identifies and generates the proper synchronization script when columns or tables do not permit updates.
  • Improves the handling of duplicated objects when database tables are mapped with each other.
  • Includes some minor fixes.

To read more about the new and updated features on this release, check the release notes.
Release date: September 16, 2019.
  • Supports SQL Server 2019 and the new features on Azure SQL Database.
  • Includes a new workspace, with an improved storage and better performance than the previous version. Tools for migration the previous workspace are provided as well.
  • The command line has been redesigned to improve performance, error handling, logging and to simplify the over data comparison via the command line.
  • A new option encrypt sensitive information in the cmd line xml config files
  • A small fix together with new option allow the UI to display tables that contain over 100 million records.
  • Fixes a small issue with the characters located in the ASCII table between the lower and upper chars.
  • Some other minor fixes.

To read more about the new and updated features on this release, check the release notes.
Release date: January 24, 2019.
  • Fixes an issue with case-insensitive comparison of text columns
  • Includes some improvements in the licensing component
Release date: February 03, 2018.
  • Adds support for SQL Server 2017
Release date: June 26, 2017.
  • Adds a data type mapping between Date columns and DateTime or DateTime2 columns.
  • Fixes a comparison issue between DateTime and DateTime2 coumns.
  • Fixes a serialization issue with an HierarchyId coumn.
Release date: September 13, 2016.
  • Fixes an issue with the export to a csv file. The file is now fully compliant with the csv specifications.
  • Includes a new "export-to-text" with custom separators and optional column headers.
Release date: August 22, 2016.
  • Includes a fix that allows you to compare and synchronize the data without having read permissions in the master database.
Release date: August 17, 2016.

New data compare version 9 with full support for SQL Server 2016 and Azure v12.
  • Supports the new SQL Server 2016
  • Supports the latest features on Azure v12
  • Includes the new command line wizard
  • Contains new data options for SQL Server 2016 features

For a full list of the new and improved features, please click here.
Release date: November 24, 2015.
  • Fixes an issue with the identity columns. The update of an identity column is now performed via a delete/insert operation.
Release date: October 26, 2015.

New version 7 with Microsoft Azure support
  • Adds supports for Microsoft Azure databases v11 & v12.
  • Allows multiple sessions for the same SQL Server databases.
  • The workspace sessions now contain the session name in addition to other session details.
  • A new landing page makes the navigation easier the first time you open the tool.
  • Includes a new popup window that contains tables and views excluded from data comparison due to Microsoft Azure restrictions.
  • Adds a "Buy Now" button in the UI that makes purchasing the comparison bundle easier.
  • Includes a small fix related to SQL Server discovery. In some cases, especially when there were no SQL Servers in the network, the UI generated an error.

For a full list of the new and improved features, click here.
Release date: December 08, 2014.
  • Contains some user interface improvements, such as a new ribbon control, improved docking, tabs and UI styles
  • Includes an improved data grid for displaying row differences
version 5.0
Release date: March 10, 2014.
  • Support for memory-optimized tables
  • Support for columnstore tables
  • An improved workspace with color schemes, new session parameters and sort orders
  • New database connection parameters
  • Other improvements and minor bug fixes

For a full list of the new and improved features, please click here.
Release date: June 03, 2013.
  • Supports saving workspaces to custom files.
  • Supports loading workspaces from custom files.
  • Fixes a small issue with the comparison result grid.
Release date: April 29, 2013.
  • Fixes a refreshing problem with data comparison grid.
  • Adds support for subscription license.
Release date: January 24, 2013.
  • Adds two new command line options for data compare where clauses.
  • Fixes an issue with the UI scaling on different resolution/DPI settings.
Release date: November 14, 2012.
  • Adds support for SQL Server 2012
  • Includes some minor fixes in the user interface
Release date: September 17, 2012.
  • Fixes an issue related to case-sensitive comparison of char columns
Release date: May 07, 2012.
  • Fixes a problem that occurs when the first column of a data candidate key is created as a descending column.
  • Fixes a problem with the data candidate index defined on columns that allow NULL values.
Release date: April 17, 2012.
  • Fixes an issue with Data Compare Command Line foreign key option.
  • Fixes a problem with the licensing component that occurred on a Windows configuration that enforces FIPS-compliant cryptography algorithms.
  • Fixes an issue with large varbinary(max) data type columns defined with FILESTREAM property.
Release date: October 10, 2011.

Minor improvements and fixes
  • Allows UI session naming without launching it
  • Adds a tooltip to the session panel that shows the left/right databases
  • Fixes an issue with the main screen resizing
  • Fixes an issue with text wrapping during print/preview
  • Adds a UI formatter for XML data type
  • Improves the comparison based on specific tables/views
version 4.0
Release date: July 06, 2011.

SQL Data Compare redesigned from the ground up
  • Graphical user interface has been completely reworked to reflect the latest standards in user interface design
  • Improved, simplified workspace that provides for a one click re-compare eliminating the hassle of repeatedly configuring comparison sessions
  • Improved memory management eliminates any database size limitations due to memory constraints. Custom built algorithms handle serialization of both data rows and script fragments as needed
  • Non-critical errors are registered and reported but do not stop the data comparison operations
  • Many new options have been added like the ability to compare views, ability to compare databases with different collations, variable transaction size etc
  • Mapping Rules allow the user to customize the way the database objects are paired together. Mapping rules include schema mapping, object name mapping and data type mapping
  • In addition of the data type compatibility the new SQL Server Data Compare provides for validating the uniqueness of the selected comparison key
  • The script for large fields is generated in fragments of a predefined size and sent to SQL Server one block at a time
version 3.5
Release date: May 26, 2010.

SQL Server 2008 R2 support and functional enhancements
  • Support for SQL Server 2008 R2
  • The passwords for SQL Server connections are now encrypted and stored in the workspace file eliminating the need to enter passwords every time you launch xSQL Object
  • An issue with early expiration of xSQL Data Compare trial period on Windows Vista and Windows 7 when the UAC is turned on has been addressed
  • Enhancements and fixes in the SQL Data Compare Command line utility including a new error code that tracks script execution errors
  • Explicit updates of the identity columns are no longer supported and will trigger data warnings
version 3.0
Release date: October 06, 2008.

SQL Server 2008 support
  • Support for SQL Server 2008 added
  • All new SQL Server 2008 data types like date, time, datetime2, datetimeoffset, geography, geometryand hierarchyID are supported
  • Spatial data types, geography and geometry are synchronized using Well-Known Text (WKT) representation
  • Improved support for CLR data types on Sql Server 2005 and Sql Server 2008 databases
version 2.5
Release date: April 16, 2007.

SQL Server 2005 support
  • Support for SQL Server 2005 added
  • Tested with Vista and 64 bit systems
  • Improved handling of very large scripts – tightly controlled resource consumption
  • Command line utility for unattended comparison and synchronization
  • Additional comparison options have been exposed on the interface to give users more control over the process
version 1.0
Release date: November 01, 2004.

SQL Data Compare V1 - compare and synchronize data in two SQL Server databases
  • Compare whole databases or select just some of the tables
  • Drop/add constraints during the synchronization process so that data being updated does not get rejected by SQL Server
  • Order tables in the synchronization scripts by FK-PK relationship to avoid data integrity violations. Unlike other tools that rely only on FK drop and add, xSQL DataCompare performs the synchronization by updating data objects in the right order
  • You pick which unique constraint or index will be used as the key for the comparison
  • Compare/synchronize selected rows only by applying a where clause on each of the tables in the comparison
Starting from:  $399
Best Value
Consider Silver Subscription - SQL Server Tools instead. It contains:
Additional Information
  • ...The speed, ease of use and most importantly, the support when there's an issue, make this suite my product of choice...
    Brenton G.
    ASPGUY-Independent Consulting, TX
  • ...It also features the best (and simplest) way to move objects and data via sql script I’ve ever seen. I’m hooked.
    Steve F.
    Creative Plumbing, GA
  • We have tested ... and compared it with 6 other products. We preferred xSQL Data Compare...
    Han van der H.
    RIVM LTR Laboratory, The Netherlands