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