Red Gate forums :: View topic - SQL Compare v11 Beta Release Notes
Return to www.red-gate.com 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
JonathanWatts



Joined: 15 Dec 2004
Posts: 399
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: 11.0.0.226

Features
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
• incremental statistics

If your deployment includes memory-optimized tables 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 (11.0.0.198), 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 11.0.0.209, 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 and upcoming improvements
We're currently working on adding support for:
• deployment using transactions for other object types when they're deployed alongside memory-optimized tables. For example, if you deploy functions alongside memory-optimized tables, there will be no transaction block for the section in the deployment script for deploying the functions
• memory-optimized table types. This latest SQL Compare beta may display incorrect SQL for these objects, and attempts to deploy them are likely to fail or result in incorrect deployment

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 won't include support for comparing and deploying backup files (native or SQL Backup) containing memory-optimized tables.

Bug fixes
This version includes the following bug fixes:
• 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

Previous releases have included the following features and fixes:
11.0.0.209
• 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

11.0.0.198
• 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

11.0.0.184
• 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]


11.0.0.142
• 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

11.0.0.116
• 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


11.0.0.71
• 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