Microsoft has announced that The SQL Server 2016 Upgrade Advisor Preview and SQL Server 2016 Community Technology Preview (CTP) 2.2 are now available for download!
This first look at SQL Server 2016 Upgrade Advisor showcases a new platform for the database upgrade tool. upgrade advisor also introduces the Stretch Database Advisor so that customer can identify the which data to make online and use transparent cold storage of azure.
The Post From SQLserverTeam….
SQL Server 2016 Upgrade Advisor Preview is a standalone tool that enables users of prior versions to find certain breaking and behavior changes as well as deprecated features in the database engine. Upgrade Advisor Preview also helps with the adoption of Stretch Database by analyzing existing database tables for fit with the new functionality based on criteria that the user selects, using the Stretch Database Advisor. Future releases will include enhancements to the upgrade rules and feature adoption advisors.
The Added features
- Users are able to add security policies including row-level security to a table that has been stretched to Azure using Stretch Database
- Master Data Services now allows compound keys, slowly changing dimension (SCD) Type 2, and syncing an entity between models
- SQL Server Reporting Services (SSRS) will now support two additional chart types, treemap and sunburst
CTP2 will also have improvements to the Query Store, Query Execution, DBCC CHECKCB performance, and Temporal Database.
Grab a copy of SQL Server 2016 CTP 2.2 play with it and explore the possibilities