IDERA SQL Comparison Toolset provides the following new features and fixed issues.
7.1.7 New features
There are no new features in this release.
7.1.7 Fixed issues
Resolves an issue causing an error during script generation
This release of IDERA SQL Data Compare resolves an issue that caused an error to appear when generating synchronization script.
Includes new DATE mapping rules
IDERA SQL Data Compare mapping rules include a new mapping between the DATE data type and other similar data types, such as DATETIME, to resolve some compatibility issues.
Corrects a serialization issue
This release fixes an issue with the serialization of the HierarchyId data type requiring additional memory. Serialization is a process that is triggered when IDERA Data Compare finds a table too big to fit in memory.
7.1.5 New features
There are no new features in this release.
7.1.5 Fixed issues
Resolves an issue causing an error before the comparison completes
This release resolves an issue causing some IDERA SQL Schema compare users to see an error message stating that an item with the same key is already added to the database. This error appeared before the comparison was complete and related to database assemblies didn't map properly due to multiple files or multiple file having the same name but a different path or extension.
Corrects an issue caused by conflicting data types
IDERA SQL Comparison Toolset 7.1.5 corrects a minor scripting issue with the user-defined types based on SQL Server native types varchar(max), nvarchar(max), and varbinary(max).
7.1 New features
Supports spatial index AUTO_GRID tessellation schemes
IDERA SQL Comparison Toolset 7.1 supports the following spatial index auto-tessellation schemes:
GEOMETRY_AUTO_GRID
Supported on SQL Server 2012, SQL Server 2014, SQL Server 2016, and Azure v12.GEOGRAPHY_AUTO_GRID
Supported on SQL Server 2012, SQL Server 2014, SQL Server 2016, and Azure v12.
Workspace displays a warning if JavaScript is disabled
The IDERA SQL Comparison Toolset Workspace now displays a warning message if JavaScript in Internet Explorer is disabled. JavaScript is not critical, but is needed for some of the Workspace functionalities. A master option in the app.config can hide this warning. The toolset requires JavaScript to be enabled for IE only.
7.1 Fixed issues
Improves data export to Microsoft Excel
IDERA SQL Data Compare includes the following resolutions regarding the export functionality:
- Export to CSV File. The exported CSV file now is fully compliant with .csv specifications. This includes the correct data separators (depending on the data type), the proper handling of the new-lines embedded in the column values, etc.
- Export to Text File. With the new option to export to text, the user can select field and row separators and to include or exclude column name.