{"id":7300,"date":"2016-03-14T16:48:26","date_gmt":"2016-03-14T15:48:26","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/"},"modified":"2016-03-14T16:48:26","modified_gmt":"2016-03-14T15:48:26","slug":"sql-server-2016-new-upgrade-advisor","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/","title":{"rendered":"SQL Server 2016: new upgrade advisor"},"content":{"rendered":"<p>I write this article because it is very interesting to see that the upgrade advisor has evolved&#8230;<br \/>\nRecently (February 11, 2016), a new version is available: <a href=\"https:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=48119\" target=\"_blank\">Microsoft\u00ae SQL Server 2016\u00ae Upgrade Advisor Preview 1.4<\/a><\/p>\n<p>The msi package is 10 MB and is named SqlAdvisor.<br \/>\nRun the msi and follow the steps like every time&#8230;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7482 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01.png\" alt=\"Upgrade advisor 01\" width=\"300\" height=\"234\" \/><\/a><\/p>\n<p>After the installation, it is easy to search the upgrade advisor tool in the search bar<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01b.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7484 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01b.png\" alt=\"Upgrade advisor 01b\" width=\"300\" height=\"188\" \/><\/a><\/p>\n<p>Like all useful tools, you can pin it to the taskbar<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01a.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7483 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01a.png\" alt=\"Upgrade advisor 01a\" width=\"300\" height=\"129\" \/><\/a><\/p>\n<p>Let&#8217;s go! \u27a1<br \/>\nThe menu bar is divided into 3 parts:<\/p>\n<ul>\n<li>Scenarios<\/li>\n<li>Active<\/li>\n<li>Others icons<\/li>\n<\/ul>\n<h3>Scenarios<\/h3>\n<p>Scenarios is the first menu and has what you can do&#8230;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-02.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7485 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-02.png\" alt=\"Upgrade advisor 02\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<h4><strong>\u00a0<\/strong>Migrate to Azure SQL Database<\/h4>\n<p>\u201cMigrate to Azure SQL Database\u201d is the first one and analyze selected databases to see if there are able to migrate in the Cloud<\/p>\n<p>To migrate to Azure, you must create an<a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/sql-database\/\" target=\"_blank\"> Azure SQL Database server<\/a> and not a Virtual Machine in Azure like me at the beginning&#8230; \ud83d\ude09<\/p>\n<p>Steps are really clear and you must just follow&#8230;<\/p>\n<p><strong><em>Step 1:<\/em> <\/strong>connect to your instance with the databases to migrate<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-04.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7487 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-04.png\" alt=\"Upgrade advisor 04\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p><em><strong>Step 2:<\/strong><\/em> select databases and run the analysis<\/p>\n<p>In the analysis result, you have the possibility to save the migration script in .sql<\/p>\n<p>I recommend to do it every time especially if it is a Production database.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-20.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7503 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-20.png\" alt=\"Upgrade advisor 20\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p><em><strong>Step 3:<\/strong><\/em> Select the target<\/p>\n<p>The first time that I tested, I created a VM in Azure and I tried to connect with the RDP link generated&#8230;<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-23.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7507 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-23.png\" alt=\"Upgrade advisor 23\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>But as you can see on the picture, I obtain an error 40.<\/p>\n<p>I created an Azure SQL Database and I connected to my &#8220;Azure instance&#8221; and I selected it<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-24.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7508 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-24.png\" alt=\"Upgrade advisor 24\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p><em><strong>Step4:<\/strong><\/em> Migrate the database<\/p>\n<p>The button &#8220;Migrate&#8221; is now enabled<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-25.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7509 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-25.png\" alt=\"Upgrade advisor 25\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>Run Migrate and then the migration process begin\u2026<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-26.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7510 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-26.png\" alt=\"Upgrade advisor 26\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>As you can see in this picture, the first step is the creation of the database, then all objects will be created.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-27.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7511 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-27.png\" alt=\"Upgrade advisor 27\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>And at the end, you have the message \u201cSuccessfully databases in 15 seconds\u201d if it is finished.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-28.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7512 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-28.png\" alt=\"Upgrade advisor 28\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>You can connect you to the cloud with SQL Server Management Studio to control if your database has been migrated.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-29.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7513 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-29.png\" alt=\"Upgrade advisor 29\" width=\"283\" height=\"209\" \/><\/a><\/p>\n<h4>Run In-Memory OLTP and Columnstore Advisor<\/h4>\n<p>This is the second Advisor and analyzes databases to be candidate to use the In-Memory OLTP and Columnstore.technolgies<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-05.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7488 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-05.png\" alt=\"Upgrade advisor 05\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>You can choose all databases or just a specific database<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-06.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7489 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-06.png\" alt=\"Upgrade advisor 06\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>Run the Advisor and then you can see the recommendations per database<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-08.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7491 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-08.png\" alt=\"Upgrade advisor 08\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<h4>Run Stretch Database Advisor<\/h4>\n<p>This advisor is for the new feature in SQL Server 2016: stretch database.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-28.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7512 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-28.png\" alt=\"Upgrade advisor 28\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>You select databases and run the advisor.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-30.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7514 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-30.png\" alt=\"Upgrade advisor 30\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>In the result, you can have some issues to be fixed to be able to migrate your database.<\/p>\n<p>You have also the possibility to run a cost estimator to see the potential cost in the Cloud for your database.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-31.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7515 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-31.png\" alt=\"Upgrade advisor 31\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<h4>Analyze and migrate to SQL Server<\/h4>\n<p>The last advisor is the \u201cclassical\u201d SQL server upgrade advisor from one version to another.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-12.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7495 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-12.png\" alt=\"Upgrade advisor 12\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>If you run migrate, you select a backup folder to migrate to a new instance as destination and then you can migrate selected databases.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-13.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7496 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-13.png\" alt=\"Upgrade advisor 13\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-14.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7497 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-14.png\" alt=\"Upgrade advisor 14\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-15.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7498 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-15.png\" alt=\"Upgrade advisor 15\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<h3>Active<\/h3>\n<p>This menu indicates all advisors that you have run during this session.<br \/>\nIt is lost when you close the tool.<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-16.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7499 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-16.png\" alt=\"Upgrade advisor 16\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<h3>Others icons<\/h3>\n<p>In the top right corner, you have 3 icons.<\/p>\n<p>The first icon is for notifications<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-17.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7500 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-17.png\" alt=\"Upgrade advisor 17\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>The second (a smiley) is to send comments to Microsoft<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-18.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7501 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-18.png\" alt=\"Upgrade advisor 18\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>The last one is about the advisor tool and all features and enhancements<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-19.png\"><img loading=\"lazy\" decoding=\"async\" class=\" size-medium wp-image-7502 aligncenter\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-19.png\" alt=\"Upgrade advisor 19\" width=\"300\" height=\"181\" \/><\/a><\/p>\n<p>After my first test, I can really write that I was nicely surprised.<br \/>\nThis new version of the advisor tool is completely different and will help DBA for all types of migration.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I write this article because it is very interesting to see that the upgrade advisor has evolved&#8230; Recently (February 11, 2016), a new version is available: Microsoft\u00ae SQL Server 2016\u00ae Upgrade Advisor Preview 1.4 The msi package is 10 MB and is named SqlAdvisor. Run the msi and follow the steps like every time&#8230; After [&hellip;]<\/p>\n","protected":false},"author":15,"featured_media":7327,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,48],"tags":[49,51,566],"type_dbi":[],"class_list":["post-7300","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-technology-survey","tag-microsoft","tag-sql-server","tag-sql-server-2016"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>SQL server 2016: new upgrade advisor<\/title>\n<meta name=\"description\" content=\"Recently (February 11, 2016), a new version of the upgrade advisor is available: Microsoft\u00ae SQL Server 2016\u00ae Upgrade Advisor Preview 1.4\" \/>\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.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2016: new upgrade advisor\" \/>\n<meta property=\"og:description\" content=\"Recently (February 11, 2016), a new version of the upgrade advisor is available: Microsoft\u00ae SQL Server 2016\u00ae Upgrade Advisor Preview 1.4\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-14T15:48:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"499\" \/>\n\t<meta property=\"og:image:height\" content=\"389\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"St\u00e9phane Haby\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"St\u00e9phane Haby\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/\"},\"author\":{\"name\":\"St\u00e9phane Haby\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"headline\":\"SQL Server 2016: new upgrade advisor\",\"datePublished\":\"2016-03-14T15:48:26+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/\"},\"wordCount\":594,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01-1.png\",\"keywords\":[\"Microsoft\",\"SQL Server\",\"SQL Server 2016\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Technology Survey\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/\",\"name\":\"SQL server 2016: new upgrade advisor\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01-1.png\",\"datePublished\":\"2016-03-14T15:48:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\"},\"description\":\"Recently (February 11, 2016), a new version of the upgrade advisor is available: Microsoft\u00ae SQL Server 2016\u00ae Upgrade Advisor Preview 1.4\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01-1.png\",\"width\":499,\"height\":389},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2016: new upgrade advisor\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b\",\"name\":\"St\u00e9phane Haby\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g\",\"caption\":\"St\u00e9phane Haby\"},\"description\":\"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL server 2016: new upgrade advisor","description":"Recently (February 11, 2016), a new version of the upgrade advisor is available: Microsoft\u00ae SQL Server 2016\u00ae Upgrade Advisor Preview 1.4","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.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2016: new upgrade advisor","og_description":"Recently (February 11, 2016), a new version of the upgrade advisor is available: Microsoft\u00ae SQL Server 2016\u00ae Upgrade Advisor Preview 1.4","og_url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/","og_site_name":"dbi Blog","article_published_time":"2016-03-14T15:48:26+00:00","og_image":[{"width":499,"height":389,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01-1.png","type":"image\/png"}],"author":"St\u00e9phane Haby","twitter_card":"summary_large_image","twitter_misc":{"Written by":"St\u00e9phane Haby","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/"},"author":{"name":"St\u00e9phane Haby","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"headline":"SQL Server 2016: new upgrade advisor","datePublished":"2016-03-14T15:48:26+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/"},"wordCount":594,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01-1.png","keywords":["Microsoft","SQL Server","SQL Server 2016"],"articleSection":["Database Administration &amp; Monitoring","Technology Survey"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/","url":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/","name":"SQL server 2016: new upgrade advisor","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01-1.png","datePublished":"2016-03-14T15:48:26+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b"},"description":"Recently (February 11, 2016), a new version of the upgrade advisor is available: Microsoft\u00ae SQL Server 2016\u00ae Upgrade Advisor Preview 1.4","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/Upgrade-advisor-01-1.png","width":499,"height":389},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/sql-server-2016-new-upgrade-advisor\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2016: new upgrade advisor"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/d0bfb7484ae81c8980fc2b11334f803b","name":"St\u00e9phane Haby","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1123227ca39a5dca608c0f72d23cd1904fee29979749bbb3a485b9438436c553?s=96&d=mm&r=g","caption":"St\u00e9phane Haby"},"description":"St\u00e9phane Haby has more than ten years of experience in Microsoft solutions. He is specialized in SQL Server technologies such as installation, migration, best practices, and performance analysis etc. He is also an expert in Microsoft Business Intelligence solutions such as SharePoint, SQL Server and Office. Futhermore, he has many years of .NET development experience in the banking sector and other industries. In France, he was one of the first people to have worked with Microsoft Team System. He has written several technical articles on this subject. St\u00e9phane Haby is Microsoft Most Valuable Professional (MVP) as well as Microsoft Certified Solutions Associate (MCSA) and\u00a0Microsoft Certified Solutions Expert (MCSE) for SQL Server 2012. He is also Microsoft Certified Technology Specialist (MCTS) and Microsoft Certified IT Professional (MCITP) for SQL Server 2008 as well as ITIL Foundation V3 certified. He holds a Engineer diploma in industrial computing and automation from France. His branch-related experience covers Chemicals &amp; Pharmaceuticals, Banking \/ Financial Services, and many other industries.","url":"https:\/\/www.dbi-services.com\/blog\/author\/stephane-haby\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=7300"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/7300\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/7327"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=7300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=7300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=7300"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=7300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}