Page History

This build includes many new features and fixed issues, including the following updates from previous releases.

4.1 New features

Windows .NET 4.0 support

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

SQL Schema Compare

• 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 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. SQL Comparison Toolset 4.1 contains additional checks and scripts the TEXTIMAGE_ON only when it is required.
• 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

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

SQL Schema Compare

• Memory-Optimized tables. SQL Server 2014 supports a new memory table and other objects associated with it, such as:
  • a new Hash index
  • a new Range index
  • a new database filegroup that contains the memory tables

  The Comparison Options window includes a new option to support memory-optimized tables. The Compare memory-optimized tables check box is located on the Comparison Options tab under the Table Options section.

• BUCKET_COUNT property. The new BUCKET_COUNT property for hash indexes is supported.
• ColumnStore indexes . SQL Server 2014 supports a new type of index called a "columnstore," which is fully supported by SQL Schema Compare.
• XML indexes . SQL Server 2014 introduces two new xml indexes and associated enhancements, such as:
  • a new primary selective xml index
  • a new secondary selective xml index
  • new xml index namespaces
  • new xml index paths
• INCREMENTAL = ON | OFF statistic . The new statistic property, INCREMENTAL = ON | OFF is supported.
• ALTER ANY DATABASE EVENT SESSION permission . The new permission type, ALTER ANY DATABASE EVENT SESSION is supported.
• Non-supported permission types . SQL Server 2014 introduces three new permission types that have server-scope, which are ignored by SQL Schema Compare is it can synchronize only those permissions that have database-scope. These new permissions include:
  • CONNECT ANY DATABASE
  • IMPERSONATE ANY LOGIN
  • SELECT ALL USER SECURABLES
• Natively-compiled stored procedures . SQL Schema Compare 4.0 fully supports natively-compiled stored procedures in SQL Server 2014.

...

This release includes two new options for the command line interface. The CompareMemoryTables option indicates whether you want to compare and synchronize memory-optimized tables. The CompareColumnStoreTables option indicates whether you want to compare and synchronize columnstore tables.

4.0 Fixed Issues

SQL Schema Compare

• This release fixes an issue related to missing dependencies associated with database synonyms.
• An issue causing a "System.NullReferenceException" error appearing during a comparison is resolved. this issue resulted from missing data compression in the table that contains the indexes.

...