{"id":13701,"date":"2015-07-22T10:00:00","date_gmt":"2015-07-22T17:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/"},"modified":"2024-01-22T22:50:14","modified_gmt":"2024-01-23T06:50:14","slug":"sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/","title":{"rendered":"SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available"},"content":{"rendered":"<p><em>Revised on July 28<\/em><\/p>\n<p style=\"margin-left:30px;\"><span style=\"color:#ff0000;\">UPDATE:<\/span><em> The issue with the initial release of\u00a0SQL Server 2016 CTP 2.2 that caused downtime during rolling upgrades across an AlwaysOn Availability Group has been corrected, and the download has been replaced.\u00a0 The download link now points to an updated build of 13.0.407.1 or higher.\u00a0 An upgrade to this build is recommended for all users of SQL Server 2016, including AlwaysOn users. For more information, <a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=398124\">visit the CTP 2.2 Release Note<\/a>.<\/em><\/p>\n<p>The <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=48119\">SQL Server 2016 Upgrade Advisor Preview <\/a>and <a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=398126\">SQL Server 2016 Community Technology Preview (CTP) 2.2<\/a> are now available for download! This first look at SQL Server 2016 Upgrade Advisor showcases a new platform for the database upgrade tool.\u00a0 It also introduces the Stretch Database Advisor, enabling customers to identify data for online, transparent cold storage in Azure. In SQL Server 2016 CTP 2.2, part of our new rapid preview model, we have made enhancements to several features that customers can try in their SQL Server 2016 development and test environments.<\/p>\n<p>In SQL Server 2016 CTP 2.2, available for download today, customers will see enhancements in several key areas<\/p>\n<ul>\n<li>Users are able to add security policies including row-level security to a table that has been stretched to Azure using Stretch Database<\/li>\n<li>Master Data Services now allows compound keys, slowly changing dimension (SCD) Type 2, and syncing an entity between models<\/li>\n<li>SQL Server Reporting Services (SSRS) will now support two additional chart types, treemap and sunburst<\/li>\n<\/ul>\n<p>CTP2 will also have improvements to the Query Store, Query Execution, DBCC CHECKCB performance, and Temporal Database.<\/p>\n<p><strong>SQL Server 2016 Upgrade Advisor Preview<\/strong><\/p>\n<p>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.\u00a0 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.<\/p>\n<p>SQL Server 2016 Upgrade Advisor Preview is available on the <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=48119\">Microsoft Download Center<\/a> and through the <a href=\"https:\/\/www.microsoft.com\/web\/downloads\/platform.aspx\">Web Platform Installer<\/a>. We invite you to try it, and to provide feedback via the built-in tool.<\/p>\n<p><strong>Download SQL Server 2016 CTP 2.2 preview today!<\/strong><\/p>\n<p>As the foundation of our end-to-end data platform, SQL Server 2016 is the biggest leap forward in Microsoft&#8217;s data platform history with real-time operational analytics, rich visualizations on mobile devices, built-in advanced analytics, new advanced security technology, and both on-premises and in the cloud.<\/p>\n<p>To learn more about the release, visit the <a href=\"http:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-2016\/default.aspx\">SQL Server 2016 preview page<\/a>.\u00a0 To experience the new, exciting features in SQL Server 2016 and the new rapid release model <a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=398126\">download the preview <\/a>or trial the preview using a virtual machine in Microsoft Azure and start evaluating the impact these new innovations can have for your business.\u00a0 Also, be sure to share your feedback on the new SQL Server 2016 capabilities <a href=\"https:\/\/connect.microsoft.com\/SQLServer\">using Microsoft\u2019s Connect tool<\/a>.\u00a0 We look forward to hearing from you<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Revised on July 28 UPDATE: The issue with the initial release of\u00a0SQL Server 2016 CTP 2.2 that caused downtime during rolling upgrades across an AlwaysOn Availability Group has been corrected, and the download has been replaced.\u00a0 The download link now points to an updated build of 13.0.407.1 or higher.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[5227,2403],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-13701","post","type-post","status-publish","format-standard","hentry","product-sql","product-sql-server-2016","content-type-updates"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"Revised on July 28 UPDATE: The issue with the initial release of\u00a0SQL Server 2016 CTP 2.2 that caused downtime during rolling upgrades across an AlwaysOn Availability Group has been corrected, and the download has been replaced.\u00a0 The download link now points to an updated build of 13.0.407.1 or higher.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2015-07-22T17:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:50:14+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available\",\"datePublished\":\"2015-07-22T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/\"},\"wordCount\":495,\"commentCount\":10,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/\",\"name\":\"SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2015-07-22T17:00:00+00:00\",\"dateModified\":\"2024-01-23T06:50:14+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available - Microsoft SQL Server Blog","og_description":"Revised on July 28 UPDATE: The issue with the initial release of\u00a0SQL Server 2016 CTP 2.2 that caused downtime during rolling upgrades across an AlwaysOn Availability Group has been corrected, and the download has been replaced.\u00a0 The download link now points to an updated build of 13.0.407.1 or higher.","og_url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-07-22T17:00:00+00:00","article_modified_time":"2024-01-23T06:50:14+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"2 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available","datePublished":"2015-07-22T17:00:00+00:00","dateModified":"2024-01-23T06:50:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/"},"wordCount":495,"commentCount":10,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/","name":"SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website"},"datePublished":"2015-07-22T17:00:00+00:00","dateModified":"2024-01-23T06:50:14+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2015\/07\/22\/sql-server-2016-upgrade-advisor-preview-and-ctp-2-2-now-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016 Upgrade Advisor Preview and CTP 2.2 now available"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/13701","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=13701"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/13701\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=13701"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=13701"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=13701"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=13701"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=13701"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=13701"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}