Page History

...

4.1 New features

Windows .NET 4.0 support

• IDERA SQL Comparison Toolset 4.1 supports all Microsoft Windows operating systems using .NET 4.0.

...

• Enhanced user interface. SQL Schema Compare includes a new ribbon control that improves the usability of the tool.
• Entity filter replace schema filters. Entity filters replace schema filters used to filter data. In the user interface, you can access these filters from the context menu of the comparison grid. The command line interface includes three additional sample xml files that provide additional information about how to use the entity filters. For more information about using these filters, see the online help accessible from within IDERA SQL Comparison Toolset.

4.1 Fixed Issues

• This release removes a table dependency that negatively affected performance for some users with large databases.
• This release fixes a table scripting issue with the TEXTIMAGE_ON clause. SQL Server requires the TEXTIMAGE_ON clause when a table contains large binary fields, such as image, text, and ntext. This issue caused the SQL Server system catalog to become out-of-date and fail to report the clause properly. IDERA SQL Comparison Toolset 4.1 contains additional checks and scripts the TEXTIMAGE_ON only when it is required.
• IDERA SQL Comparison Toolset 4.1 includes a fix related to dependencies on SQL Server 2005. This issue occurred on some SQL Server 2008 databases when the compatibility level was set to SQL Server 2005.

4.0 New features

SQL Server 2014 Support

IDERA SQL Comparison Toolset 4.0 supports the use of SQL Server 2014 with the following notes:

...

Filegroup mappings allow you to change the way filegroups are mapped, compared, scripted, and synchronized. IDERA SQL Comparison Toolset now offers the following options for mapping filegroups:

...

New SQL Comparison Toolset workspace

IDERA SQL Comparison Toolset 4.0 features a new, easier-to-use interface for navigating through session history.

• The navigation tree now offers two tabs to separate live databases from database snapshots that are added to the workspace.
• Workspace links are grouped at the top of the window.
• You can adjust the width of the tree panel for ease-of use.
• The Application Settings window now allows you to customize the look and feel of the workspace including changing the colors of sessions to group similar sessions together.
• The Customize Session window includes new sorting options allow you to organize and manage your session history, edit session data such as name, description, and count. The Execution Count field in the Customize Session window indicates the number of times a session is launched.

IDERA SQL Comparison Toolset removal from the SQL Toolbox framework

The IDERA SQL Comparison Toolset is now separated from the SQL Toolbox, meaning that it is no longer necessary to install the SQL Toolbox framework prior to installing IDERA SQL Comparison Toolset.

New CLI options

...

2.1.2 New features

SQL Server 2012 support

IDERA SQL Comparison Toolset 2.1.2 supports the use of SQL Server 2012.

...

SQL Server 2012 Testing Compatibility

IDERA SQL Comparison Toolset 2.1 is SQL Server 2012 RC0 compatible in non-production environments.

Updated License Key Activation Service

IDERA SQL Comparison Toolset 2.1 now includes an updated license key activation service.

...

• Enhanced support for comparing large databases. Enhanced memory utilization, custom algorithms, and a new user interface improve the performance when comparing large databases.
• Improved Error Handling. Improvements to the error handling allow for non-critical errors to be logged, but not stop the data operations. A full error log is created and saved for review and analysis.
• Enhanced data handling. IDERA SQL Data Compare now uses SQL native types instead of .NET types to read the data from SQL Server databases which provides faster read time and mirror database types.
• Improved Scripting. IDERA SQL Data Compare has improved scripting of binary fields and large text fields.

...

...