version 11.0.0.0
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.
version 10.0.0.0
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.
version 9.5.2.0
Release date: January 24, 2019.
- Fixes an issue with case-insensitive comparison of text columns
- Includes some improvements in the licensing component
version 9.5.0.0
Release date: February 03, 2018.
- Adds support for SQL Server 2017
version 9.0.5.0
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.
version 9.0.2.0
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.
version 9.0.1.0
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.
version 9.0.0.0
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.
version 7.0.1.0
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.
version 7.0.0.0
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.
version 5.1.0.0
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.
version 4.0.8.0
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.
version 4.0.7.5
Release date: April 29, 2013.
- Fixes a refreshing problem with data comparison grid.
- Adds support for subscription license.
version 4.0.7.0
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.
version 4.0.6.0
Release date: November 14, 2012.
- Adds support for SQL Server 2012
- Includes some minor fixes in the user interface
version 4.0.5.5
Release date: September 17, 2012.
- Fixes an issue related to case-sensitive comparison of char columns
version 4.0.5.0
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.
version 4.0.4.0
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.
version 4.0.1.5
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