Red Gate forums :: View topic - SQL Compare v11 Beta Release Notes
Return to RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 11
SQL Compare 11 forum

SQL Compare v11 Beta Release Notes

Search in SQL Compare 11 forum
Post new topic   Reply to topic
Jump to:  
Author Message

Joined: 15 Dec 2004
Posts: 401
Location: Red Gate Software

PostPosted: Wed Jun 18, 2014 3:03 pm    Post subject: SQL Compare v11 Beta Release Notes Reply with quote

You can download the beta of SQL Compare 11 from the Red Gate website.

SQL Compare 11 is still in development and therefore is not a finished product and may not work in your particular environment.

We'd really appreciate your feedback.

Current version:

This version includes the following features:
• Comparison and deployment of memory-optimized table types
• Backup commands are included in the deployment script
When you select the ‘Back up before deployment’ option in the deployment wizard, the backup commands are now included at the top of the deployment script. This means you can back up the target even if you run the deployment script in Management Studio.
• ‘Do not add error handling statements to deployment scripts’ project option
When you run the deployment script in Management Studio, this option allows the deployment script to fail when an error is encountered. You can only select this option if transactions are not used in deployment scripts. When you deploy directly from SQL Compare, a deployment is always terminated when an error is encountered.

If your deployment includes memory-optimized tables, memory-optimized table types and/or natively compiled stored procedures, you need to:
make sure that the target database has a memory-optimized filegroup
turn on the ‘Do not use transactions in deployment scripts’ option

Changes to beta features
In the previous beta version (, memory-optimized tables were deployed as disk-based tables when downgrading to older SQL Server versions (SQL Server 2012 or earlier, or a SQL Server 2014 database with compatibility levels 100 and 110). This is not consistent with how SQL Compare used to handle deployment of new object types to older SQL Server.

From version, memory-optimized tables will always be deployed as memory-optimized tables regardless of the version of the server. However, users will get a warning before deployment if the target database is not SQL 2014.

Behavioral differences
• If you turn on the ‘Ignore indexes’ option, differences in indexes for memory-optimized tables are ignored if the only differences between the tables are the indexes. However, if there are other differences between the tables, all indexes will be deployed.
• The ‘Ignore collations’ option is not applied to memory-optimized tables.

Known issues
• If the ‘Ignore filegroups, partition schemes and partition functions’ option is enabled, the deployment of incremental statistics might fail if they rely on partition schemes or functions which are being ignored
• SQL Compare 11 doesn’t support comparing and deploying backup files (native or SQL Backup) containing memory-optimized tables

Bug fixes
This version includes the following bug fixes:
• Fix for the trial expiry issue encountered in version when upgrading from a previous beta version
• SC-6875: Fix for the issue where inconsistent comparison results are shown when reversing compare direction between scripts folder and database for compressed partitioned tables
• SC-6438: (Regression) Registering partition functions with null values no longer throws an error
• SC-6263: Serializing/deserializing partition functions with null values no longer causes NullReferenceException
• SC-7319: Adding dependencies for certain CLR in backups no longer causes NullReferenceException
• SC-6632: ALTER SCHEMA statement is now included for objects whose name has not changed but schema has
• SC-6650: When using /include="StaticData" and a static data table's primary key consists of a field that is a user-defined table, comparison no longer fails with "Unsupported column type - Empty"
• SC-6985: TesselationScheme is now correctly registered on spatial indexes
• SC-6750: A table rebuild is no longer incorrectly scripted out when deploying changes in tables with FILESTREAM columns
• SC-7370: Sequences no longer show differences when they are equal
• SC-7464: A duplicate extended property name when registering user-defined table type
• SC-7451: Fix for the issue where ANSI_NULLS is reported incorrectly in SQL Server 2005 and 2008 after certain ALTER VIEW operations
• SC-6051: Partitioned tables no longer rebuild when the number of partitions of the underlying partition schemes change
• SC-5662: Clicking Owner Mapping tab followed by Table Mapping tab no longer incorrectly shows “No data source selected” when data sources have been set up
• SC-7399: ALTER INDEX REBUILD statements in scripts folder are now parsed
• SC-7424: Columstore indexes are now scripted out regardless of the target database’s compatibility mode
• SC-5853: System.OverflowException is no longer thrown for large values of syscolumns.columnID associated with table columns

Previous releases have included the following features and fixes:
• This version includes additional support for the new SQL Server 2014 features. SQL Compare can now compare and deploy natively compiled stored procedures, clustered columnstore indexes and incremental statistics
• SC-7378: Deployment no longer fails when rebuilding FILESTREAM table with ‘Ignore system named constraint and index names’ option enabled
• SC-7423: Scripts folder no longer contains duplicate constraint when "Database Project Compatible script folder output' option is enabled
• SC-7415: Creating snapshots from backup no longer fails with null reference exception
• SC-6605: Creating identity key with large seed value no longer causes conversion overflow exception
• SC-7402: Circular reference error is no longer thrown incorrectly on views in scripts folder
• SC-7023: Fix for the issue where mapping owners for comparison throws an error
• SC-7368: Parsing now works when hex value is used in OPTIMIZE FOR statement
• SC-6879: Fix for the issue where automatic column mapping always forces a table rebuild
• This version includes additional support for memory-optimized tables. SQL Compare can now drop and recreate database level triggers for CREATE TABLE and DROP TABLE statements on a target database when memory-optimized tables are deployed
• SC-7359: Fix for the issue where if SQL Compare needs to rebuild a memory optimized table when the "Ignore Filegroups" option is disabled the deployment script contains an empty ON clause on a CREATE TABLE statement (used to create a temporary table to house the memory optimised table's data whilst it is rebuilt)
• SC-7376: NullReferenceException is no longer thrown when schemas get unmapped
• SC-7003: Use proper icon for Search Property Lists
• SC-7348: Search Property Lists and Sequences no longer show as “undefined” in Comparison Report
• SC-6837: Sequences are no longer deployed when they are filtered out
• SC-7314: Fix the issue where tables with clustered columnstore index with DATA_COMPRESSION = COLUMNSTORE_ARCHIVE does not deploy
• SC-7276: Rebuilding table with different schema no long copies data from wrong schema
• SC-3399: DDL triggers created during synchronization no longer fire when ‘Disable DDL triggers’ option is turned on
• SC-7335: Registering a blank Search Property List (without search properties) no longer causes InvalidCastException
• SC-7012: Search property list now appears in the filter list
• This version includes additional support for memory-optimized tables. SQL Compare can now:
- deploy memory-optimized tables from a SQL Server 2014 database to a database on an older version of SQL Server as disk-based tables
- deploy memory-optimized tables from a SQL Server 2014 database to a SQL Server 2014 database with compatibility levels 100 and 110 as disk-based tables
- overwrite memory-optimized tables on a SQL Server 2014 database with disk-based tables
• SC-7331: Foreign keys in referencing tables are no longer dropped and recreated when the referencing tables are not selected for deployment as dependencies
• SC-7321: Fix for the issue where tables on case-sensitive databases in non-default schemas can’t be mapped
• SC-6814: Deploying permission changes to scripts folder no longer deletes all permissions and leaves the scripts blank
• SC-5287: Fix for the issue where SQL Compare is unable to load DLLs related to SQL Source Control
• This version includes support for memory-optimized tables. SQL Compare can now:
- perform a deployment to create, drop and rebuild memory-optimized tables on SQL Server 2014 databases
- drop and recreate database level event notifications for CREATE TABLE and DROP TABLE statements when memory-optimized tables are deployed
• SC-7260: Fillfactor option no longer appears in user-defined table types
• SC-5164: Fix for the issue where SQL Compare attempts to re-add extended properties when altering a function with existing extended properties
• SC-7248: Assemblies with circular dependencies on other assemblies no longer causes stackoverflow exception
• SC-5443: Using drop and create instead of alter option no longer throws an error after dropping a view then trying to refresh it
• SC-7142: Migration scripts are now retrieved by command line
• SC-6835: *= operator in stored procedures is now properly parsed
• SC-7063: A TIMEOUT value of -1 when retrieving messages from a queue no longer causes parsing error[/u]
• This version includes full support for nonclustered columnstore indexes (SC-5831)
• SC-6142: Computed column using XML Schema is now handled correctly from scripts folder
• SC-6315: Deployment script now shows correct transaction isolation level when transaction isolation level (in Application Options) is changed and “Deploy All Dependencies” is unchecked in the Deployment Wizard
• SC-7172: Command line no longer ignores /transactionIsolationLevel option
• SC-7206: SQL Compare no longer causes an error when a CLR assembly references a system assembly
• SC-6317 - ‘Drop and create instead of alter’ option does not work on command line with project using command line data sources
• SC-7114 - Fixed a situation where on SQL Server 2008 some indexed tables were reporting false differences
• SC-6590 - Fixed an issue where multiple indexes on a table create causes issues with partitioned fields
• SC-7178 - Resolved an issue which caused a decrease in performance in SQL Compare 10.7
• SC-7176 - We are now correctly obfuscating the SQL Compare Engine
• SC-7084 - Fixed an issue where a corrupted project could crash the project browse dialog
• SC-6584 - Fixed an issue where the Close project dialog would appear under other windows, making it appear SQL Compare had frozen
• SC-6796 - It is now possible to compare SQL 2014 databases to empty scripts folders without errors
• SC-4077 - The ignore WITH NOCHECK option is now implemented correctly and is now inline with the documentation
• SC-6564 - SQL Compare no longer scripts GRANTS on wrong columns after dropping a column
• Support inline specification of CLUSTERED and NONCLUSTERED indexes for disk-based tables and user-defined table types
• SC-7101 - Command line no longer displays a Ninject error when project uses source-controlled database as data source
• SC-7056 Choosing SQL Server 2014 Management Studio as SQL editor no longer disables the Custom Program controls
• SC-5187, SC-6522 We have fixed an number of exceptions that used to occur in the progress dialog
• SC-6008, SC-5982, SC-5937, SC-5843, SC-5833, SC-5825 and SC-5819 We have fixed an number of issues where a MissingManifestResourceException could be raised by the check for updates functionality
• SC-5551 We have fixed an issue where a NullReferenceException could occur when the PROCESSOR_ARCHITECTURE environment variable isn’t set
• SC-5365 We fixed an issue which causes a NullReferenceException in SQL Source Control
Jonathan Watts

-Project Manager
-Red Gate Software Ltd

Last edited by JonathanWatts on Thu Jul 10, 2014 10:03 am; edited 1 time in total
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2005 phpBB Group