{"id":482,"date":"2012-06-07T16:45:39","date_gmt":"2012-06-07T16:45:39","guid":{"rendered":"\/blogs\/glenn\/post\/How-to-Perform-a-Rolling-Edition-Upgrade-While-Using-Database-Mirroring.aspx"},"modified":"2019-03-08T13:37:26","modified_gmt":"2019-03-08T21:37:26","slug":"how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/","title":{"rendered":"How to Perform a Rolling Edition Upgrade While Using Database Mirroring"},"content":{"rendered":"<p>Imagine that you are using synchronous database mirroring with SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012 Standard Edition. Now, you want to upgrade the instances on both sides of the mirroring partnership to SQL Server Enterprise Edition.\u00a0 This will let you take advantage of some of the valuable Enterprise Edition-only features in that version of SQL Server.\u00a0 These include online index operations, data compression, table partitioning, etc.. How would you go about doing this without having to take a long outage or re-establish your mirroring partnership?<\/p>\n<h2>Rolling Edition Upgrade<\/h2>\n<p>I had this question come up recently, but I was not 100% sure of the best answer without some testing. Remember, this is going to be a rolling <strong><span style=\"text-decoration: underline;\">edition<\/span><\/strong> upgrade from SQL Server Standard Edition to SQL Server Enterprise Edition. This is different from a rolling <strong><span style=\"text-decoration: underline;\">version<\/span><\/strong> upgrade from an older major version of SQL Server to a newer major version of SQL Server. If you need to do a rolling version upgrade, you can use log shipping or database mirroring to get it done with a very short outage.<\/p>\n<p>Here is some guidance from Microsoft about how to do a rolling version upgrade: <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/database-mirroring\/upgrading-mirrored-instances\">How to: Minimize Downtime for Mirrored Databases When Upgrading Server Instances<\/a><\/p>\n<h2>SQL Server Versions and Editions<\/h2>\n<p>Let&#8217;s cover some background on the terminology that Microsoft uses to differentiate between the different flavors of the SQL Server boxed product.<\/p>\n<p>First, you have the <strong><span style=\"text-decoration: underline;\">major version<\/span><\/strong> of SQL Server, which could be one of these:<\/p>\n<ul>\n<li>SQL Server 2005<\/li>\n<li>SQL Server 2008<\/li>\n<li>SQL Server 2008 R2<\/li>\n<li>SQL Server 2012<\/li>\n<\/ul>\n<p>You also have the <strong><span style=\"text-decoration: underline;\">edition<\/span><\/strong> of SQL Server, which depending on the major version involved could be one of these:<\/p>\n<ul>\n<li>SQL Server Express Edition<\/li>\n<li>SQL Server Workgroup Edition<\/li>\n<li>SQL Server Standard Edition<\/li>\n<li>SQL Server Business Intelligence Edition<\/li>\n<li>SQL Server Developer Edition<\/li>\n<li>SQL Server Enterprise Edition<\/li>\n<li>SQL Server Data Center Edition<\/li>\n<\/ul>\n<p>Most people will be dealing with upgrading from SQL Server Standard Edition to SQL Server Enterprise Edition, which is what we will discuss here.<\/p>\n<p>If you need to do a rolling edition upgrade, you need to make sure that you have an existing database mirroring partnership for all of the databases that need to be mirrored between the two instances. This is because SQL Server will prevent you from establishing a new mirroring partnership between databases that are on different editions of SQL Server.<\/p>\n<p>Figure 1 shows the error message that you will get from the \u201cConfigure Database Mirroring Security Wizard\u201d if you try to create a new mirroring partnership between a database on an instance running SQL Server 2008 R2 Standard Edition to a database running on SQL Server 2008 R2 Enterprise Edition.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/23387c46\/image.png\"><img fetchpriority=\"high\" decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/1b40d9e4\/image_thumb.png\" alt=\"image\" width=\"537\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 1: Error Message When Trying to Create a New Mirroring Partnership between Different Editions of SQL Server<\/strong><\/p>\n<p>This means that you will need an existing mirroring partnership between your databases on the two instances before you attempt to do an Edition Upgrade of SQL Server from Standard Edition to Enterprise Edition. In order to minimize your downtime, and actually perform a rolling edition upgrade, you are going to want to upgrade the mirror instance first. You start this out by running Setup.exe from the SQL Server installation media, and then choosing Maintenance in the left hand pane of the screen, as shown in Figure 2.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/615196f7\/image.png\"><img decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/6ba2bb57\/image_thumb.png\" alt=\"image\" width=\"644\" height=\"483\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 2: Maintenance Screen Showing Edition Upgrade Option<\/strong><\/p>\n<p>After this, you just have to click though several different screens for various setup checks and licensing prompts as shown in Figures 3 through 10. The actual installation portion of the Edition Upgrade will take about 30 seconds. During the install, the mirrored database(s) will go into a disconnected state for about 10 seconds, and then will automatically reconnect and change from a synchronizing to a synchronized state.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/6aca556d\/image.png\"><img decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/657b6ebc\/image_thumb.png\" alt=\"image\" width=\"644\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 3: Setup Support Rules Screen Results<\/strong><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/1db9e5d5\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/0f0f39f0\/image_thumb.png\" alt=\"image\" width=\"644\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 4: Product Key Screen<\/strong><\/p>\n<p>You will have to enter a valid product key for SQL Server 2008 R2 Enterprise Edition.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/3c2426be\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/6d43615e\/image_thumb.png\" alt=\"image\" width=\"644\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 5: License Terms Screen<\/strong><\/p>\n<p>You must accept the license terms in order to proceed.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/2c34e1fa\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/2b5c7c10\/image_thumb.png\" alt=\"image\" width=\"644\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 6: Select Instance Screen<\/strong><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/37ea292c\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/293f7d47\/image_thumb.png\" alt=\"image\" width=\"644\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 7: Edition Upgrade Rules Screen<\/strong><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/3cec66db\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/473d8b3b\/image_thumb.png\" alt=\"image\" width=\"644\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 8: Edition Upgrade Detailed Report Screen<\/strong><\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/3acf6812\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/5a120ee5\/image_thumb.png\" alt=\"image\" width=\"644\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 9: Ready to Upgrade Edition Screen<\/strong><\/p>\n<p>After you click on Upgrade, it will take about 30 seconds to complete the process<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/5939a8fb\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/31932cd1\/image_thumb.png\" alt=\"image\" width=\"644\" height=\"484\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 10: Upgrade Complete Screen<\/strong><\/p>\n<p>Here is what you want to see when you are done with this instance.<\/p>\n<p><a href=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/3be45131\/image.png\"><img loading=\"lazy\" decoding=\"async\" style=\"background-image: none; padding-left: 0px; padding-right: 0px; display: inline; padding-top: 0px; border: 0px;\" title=\"image\" src=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/3b0beb47\/image_thumb.png\" alt=\"image\" width=\"644\" height=\"234\" border=\"0\" \/><\/a><\/p>\n<p><strong>Figure 11: SSMS showing Mirror instance upgraded to SQL Server 2008 R2 Enterprise Edition<\/strong><\/p>\n<h2>Confirming the Edition Upgrade<\/h2>\n<p>Running <a href=\"mailto:SELECT@@VERSION\">SELECT @@VERSION<\/a> shows that this instance has been upgraded to SQL Server 2008 R2 Enterprise Edition. You can also see that the mirrored database has reconnected and is also synchronized. Your next step would be to failover all of the mirrored user databases from the original Principal instance (which is still running on SQL Server 2008 R2 Standard Edition) to this newly upgraded instance. After that, you would repeat the Edition Upgrade process on the other instance, with the same steps and results. After both sides of the mirroring partnership have been upgraded to SQL Server 2008 R2 Enterprise Edition, you would probably want to failover all of your mirrored user databases back to the original Principal instance so that you don\u2019t end up violating the licensing requirements that allow you to only need licenses for the active side of the mirroring partnership.<\/p>\n<h2>Conclusion<\/h2>\n<p>The key takeaway of this exercise is that by following these steps, you can perform a rolling Edition Upgrade with an existing database mirroring partnership. You can do this without having to reinitialize your mirrored databases or take a longer outage while you are doing an Edition Upgrade of the active instance.\u00a0 You do have to have an existing mirroring partnership to make this work. This is because SQL Server will not let you create a new mirroring partnership between SQL Server Standard Edition and SQL Server Enterprise Edition.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Imagine that you are using synchronous database mirroring with SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012 Standard Edition. Now, you want to upgrade the instances on both sides of the mirroring partnership to SQL Server Enterprise Edition.\u00a0 This will let you take advantage of some of the valuable [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14,29,30,31],"tags":[75,74],"class_list":["post-482","post","type-post","status-publish","format-standard","hentry","category-sql-server-database-mirroring","category-sql-server-2008","category-sql-server-2008-r2","category-sql-server-2012","tag-database-mirroring","tag-edition-upgrade"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to Perform a Rolling Edition Upgrade While Using Database Mirroring - Glenn Berry<\/title>\n<meta name=\"description\" content=\"Glenn Berry describes how to perform a rolling edition upgrade while using database mirroring. Changing the Edition of SQL Server\" \/>\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.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Perform a Rolling Edition Upgrade While Using Database Mirroring - Glenn Berry\" \/>\n<meta property=\"og:description\" content=\"Glenn Berry describes how to perform a rolling edition upgrade while using database mirroring. Changing the Edition of SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/\" \/>\n<meta property=\"og:site_name\" content=\"Glenn Berry\" \/>\n<meta property=\"article:published_time\" content=\"2012-06-07T16:45:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-03-08T21:37:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/1b40d9e4\/image_thumb.png\" \/>\n<meta name=\"author\" content=\"Glenn Berry\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Glenn Berry\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/\",\"name\":\"How to Perform a Rolling Edition Upgrade While Using Database Mirroring - Glenn Berry\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/1b40d9e4\/image_thumb.png\",\"datePublished\":\"2012-06-07T16:45:39+00:00\",\"dateModified\":\"2019-03-08T21:37:26+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\"},\"description\":\"Glenn Berry describes how to perform a rolling edition upgrade while using database mirroring. Changing the Edition of SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/#primaryimage\",\"url\":\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/1b40d9e4\/image_thumb.png\",\"contentUrl\":\"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/1b40d9e4\/image_thumb.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Perform a Rolling Edition Upgrade While Using Database Mirroring\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\",\"name\":\"Glenn Berry\",\"description\":\"Semi-random musings about SQL Server performance\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7\",\"name\":\"Glenn Berry\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g\",\"caption\":\"Glenn Berry\"},\"sameAs\":[\"https:\/\/www.sqlskills.com\/blogs\/glenn\/\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Perform a Rolling Edition Upgrade While Using Database Mirroring - Glenn Berry","description":"Glenn Berry describes how to perform a rolling edition upgrade while using database mirroring. Changing the Edition of SQL Server","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.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/","og_locale":"en_US","og_type":"article","og_title":"How to Perform a Rolling Edition Upgrade While Using Database Mirroring - Glenn Berry","og_description":"Glenn Berry describes how to perform a rolling edition upgrade while using database mirroring. Changing the Edition of SQL Server","og_url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/","og_site_name":"Glenn Berry","article_published_time":"2012-06-07T16:45:39+00:00","article_modified_time":"2019-03-08T21:37:26+00:00","og_image":[{"url":"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/1b40d9e4\/image_thumb.png","type":"","width":"","height":""}],"author":"Glenn Berry","twitter_misc":{"Written by":"Glenn Berry","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/","name":"How to Perform a Rolling Edition Upgrade While Using Database Mirroring - Glenn Berry","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/#primaryimage"},"image":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/#primaryimage"},"thumbnailUrl":"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/1b40d9e4\/image_thumb.png","datePublished":"2012-06-07T16:45:39+00:00","dateModified":"2019-03-08T21:37:26+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7"},"description":"Glenn Berry describes how to perform a rolling edition upgrade while using database mirroring. Changing the Edition of SQL Server","breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/#primaryimage","url":"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/1b40d9e4\/image_thumb.png","contentUrl":"https:\/\/www.SQLskills.com\/blogs\/glenn\/wp-content\/uploads\/windows-live-writer\/639030e17a99\/1b40d9e4\/image_thumb.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/how-to-perform-a-rolling-edition-upgrade-while-using-database-mirroring\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/glenn\/"},{"@type":"ListItem","position":2,"name":"How to Perform a Rolling Edition Upgrade While Using Database Mirroring"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/","name":"Glenn Berry","description":"Semi-random musings about SQL Server performance","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/glenn\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/57a8972435106bac7970692fcf5edfa7","name":"Glenn Berry","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/glenn\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/64bdac8830f25f2f8cc780f8a1286c66ff1182218009271e7a953639596f7e25?s=96&d=mm&r=g","caption":"Glenn Berry"},"sameAs":["https:\/\/www.sqlskills.com\/blogs\/glenn\/"],"url":"https:\/\/www.sqlskills.com\/blogs\/glenn\/author\/glenn\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/482","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/comments?post=482"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/posts\/482\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/media?parent=482"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/categories?post=482"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/glenn\/wp-json\/wp\/v2\/tags?post=482"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}