Data Compare for SQL Server - Release History

September 30, 2022
  • Adds support for SQL Server 2022 and the latest features on Azure Databases.
  • Fixes an issue with the comparison of built-in CLR types: geography, geometry, hierarchy etc.
April 23, 2020
  • Fixes an issue related to the table comparison on SQL Server 2019.
  • Removes the workspace "Open" and "Save As" options from the ribbon app menu. These functionalities are no longer supported.
January 13, 2020
  • Fixes an issue related to the where clause validation.
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.
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.
January 24, 2019
  • Fixes an issue with case-insensitive comparison of text columns
  • Includes some improvements in the licensing component
February 03, 2018
  • Adds support for SQL Server 2017
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.
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.
August 22, 2016
  • Includes a fix that allows you to compare and synchronize the data without having read permissions in the master database.
August 17, 2016
  • 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
New data compare version 9 with full support for SQL Server 2016 and Azure v12.
November 24, 2015
  • Fixes an issue with the identity columns. The update of an identity column is now performed via a delete/insert operation.
October 26, 2015
  • 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.
New version 7 with Microsoft Azure support
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
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
June 03, 2013
  • Supports saving workspaces to custom files.
  • Supports loading workspaces from custom files.
  • Fixes a small issue with the comparison result grid.
April 29, 2013
  • Fixes a refreshing problem with data comparison grid.
  • Adds support for subscription license.
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.
November 14, 2012
  • Adds support for SQL Server 2012
  • Includes some minor fixes in the user interface
September 17, 2012
  • Fixes an issue related to case-sensitive comparison of char columns
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.
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.
October 10, 2011
  • 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
Minor improvements and fixes
version 4.0
July 06, 2011
  • 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
SQL Data Compare redesigned from the ground up
version 3.5
May 26, 2010
  • 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
SQL Server 2008 R2 support and functional enhancements
version 3.0
October 06, 2008
  • 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
SQL Server 2008 support
version 2.5
April 16, 2007
  • 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
SQL Server 2005 support
version 1.0
November 01, 2004
  • 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
SQL Data Compare V1 - compare and synchronize data in two SQL Server databases