Xjyuk

Is Trump personally blocking people on Twitter?

Why did my rum cake turn black?

Are randomly-generated passwords starting with "a" less secure?

affect vs effect

Was adding milk to tea started to reduce employee tea break time?

Referring to different instances of the same character in time travel

How the name "craqueuhhe" is read

Extract an attribute value from XML

How do I determine whether a permit is required for a new gas line?

Are there any double stars that I can actually see orbit each other?

Crowbar circuit causes unexpected behavior for op amp circuit

Machine learning and operations research projects

Why can't supermassive black holes merge? (or can they?)

Cubic programming and beyond?

Correct use of ergeben?

Is this floating-point optimization allowed?

Why would guns not work in the dungeon?

What can the U.S. government do to prevent powerful people to get extremely favorable plea bargain deals like Jeff Epstein?

If a specific mass of air is polluted, will the pollution stick with it?

Why does the autopilot disengage even when it does not receive pilot input?

Did any of the founding fathers anticipate Lysander Spooner's criticism of the constitution?

Optimising Table wrapping over a Select

What's a moment that's more impactful on a reread called?

How do I take a fraction to a negative power?

SQL2008R2 Edition Upgrade

Upgrade SQL Server 2012 Express to Evaluation EditionSQL Server 2000 : Upgrade from Personal Edition to Enterprise EditionUpgrading SQL Server 2008 Standard to EnterpriseUsing Standard Edition for a VLDBReplication To Enterprise & Standard Edition subscribersUpgrade from SQL Server 2008 R2 Enterprise to SQL Server 2016 Standard Edition?Make Edition Upgrade in a SQL cluster scenarioSQL Server Editions: Backup restore of Enterprise Edition 2014 on Standard Edition 2017Oracle Upgrade Standard to Enterprise EditionPerformance Issues on MSSQL Server Web Edition

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

1

I have several SQL2008R2 Standard Edition instances that we need to upgrade to SQL2008R2 Enterprise Edition.

If I have valid SQL2017 Enterprise Edition (with SA) PIDs do I need to have SQL2008R2 Enterprise Edition media to complete the upgrade.

Please don't recommend that I just upgrade to SQL2017. :) It is not an option at this time.

sql-server sql-server-2008 upgrade standard-edition enterprise-edition

share|improve this question

edited 6 hours ago

John Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

asked 8 hours ago

RayRay

18144 bronze badges

• 
  
  
  

  
  6
  

  
  
  
  
  
  

  
  
  You realize 2008/R2 is completely unsupported as of 2 days ago, right?
  
  – Max Vernon
  8 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Licensing questions are off-topic. But typically, carrying SA (Software Assurance) on your SQL 2017 Enterprise Edition license should entitle you to install older versions. Following the general outline here -- blogs.msdn.microsoft.com/petersad/2011/01/24/… -- what happens when you enter the SQL 2017 product key during the Edition Upgrade wizard within the Installation Center from the SQL 2008 R2 Standard Edition's media? (And Max makes a very good point. Even if you can't go all the way to 2017, at least get to 2012 or 2014 or 2016.)
  
  – Doug Deden
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks John, I was under the impression I posted to Database Administrators and assumed an upgrade question would be acceptable. If I am mistaken I humbly apologize. If you would like me to rehash the months and years of pleading to upgrade to a newer version, then I will be happy to go further off-topic. If someone will step-up and provide the 2+ staff years for regression testing then I will approach management yet again. It has taken 2 years and an order of magnitude increase in Transaction Rate/Database size to get the edition upgrade approved.
  
  – Ray
  6 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Max, Yes I am painfully aware of the support status of SQL2008R2, Windows Server 2008, VB 6.0, and several other technologies which remain widely in use.
  
  – Ray
  6 hours ago
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  This question has nothing to do with licensing. The question is how to perform the edition upgrade, not what the licensing implications are.
  
  – David Browne - Microsoft
  5 hours ago
  
  

  
  
  
  

add a comment | 

1

I have several SQL2008R2 Standard Edition instances that we need to upgrade to SQL2008R2 Enterprise Edition.

If I have valid SQL2017 Enterprise Edition (with SA) PIDs do I need to have SQL2008R2 Enterprise Edition media to complete the upgrade.

Please don't recommend that I just upgrade to SQL2017. :) It is not an option at this time.

sql-server sql-server-2008 upgrade standard-edition enterprise-edition

share|improve this question

edited 6 hours ago

John Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

asked 8 hours ago

RayRay

18144 bronze badges

• 
  
  
  

  
  6
  

  
  
  
  
  
  

  
  
  You realize 2008/R2 is completely unsupported as of 2 days ago, right?
  
  – Max Vernon
  8 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Licensing questions are off-topic. But typically, carrying SA (Software Assurance) on your SQL 2017 Enterprise Edition license should entitle you to install older versions. Following the general outline here -- blogs.msdn.microsoft.com/petersad/2011/01/24/… -- what happens when you enter the SQL 2017 product key during the Edition Upgrade wizard within the Installation Center from the SQL 2008 R2 Standard Edition's media? (And Max makes a very good point. Even if you can't go all the way to 2017, at least get to 2012 or 2014 or 2016.)
  
  – Doug Deden
  7 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks John, I was under the impression I posted to Database Administrators and assumed an upgrade question would be acceptable. If I am mistaken I humbly apologize. If you would like me to rehash the months and years of pleading to upgrade to a newer version, then I will be happy to go further off-topic. If someone will step-up and provide the 2+ staff years for regression testing then I will approach management yet again. It has taken 2 years and an order of magnitude increase in Transaction Rate/Database size to get the edition upgrade approved.
  
  – Ray
  6 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Hi Max, Yes I am painfully aware of the support status of SQL2008R2, Windows Server 2008, VB 6.0, and several other technologies which remain widely in use.
  
  – Ray
  6 hours ago
  

  
  
  
  


• 
  
  
  

  
  2
  

  
  
  
  
  
  

  
  
  This question has nothing to do with licensing. The question is how to perform the edition upgrade, not what the licensing implications are.
  
  – David Browne - Microsoft
  5 hours ago
  
  

  
  
  
  

add a comment | 

I have several SQL2008R2 Standard Edition instances that we need to upgrade to SQL2008R2 Enterprise Edition.

If I have valid SQL2017 Enterprise Edition (with SA) PIDs do I need to have SQL2008R2 Enterprise Edition media to complete the upgrade.

Please don't recommend that I just upgrade to SQL2017. :) It is not an option at this time.

sql-server sql-server-2008 upgrade standard-edition enterprise-edition

share|improve this question

edited 6 hours ago

John Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

asked 8 hours ago

RayRay

18144 bronze badges

share|improve this question

edited 6 hours ago

John Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

asked 8 hours ago

RayRay

18144 bronze badges

share|improve this question

edited 6 hours ago

John Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

asked 8 hours ago

RayRay

18144 bronze badges

edited 6 hours ago

John Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

edited 6 hours ago

John Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

asked 8 hours ago

RayRay

18144 bronze badges

asked 8 hours ago

RayRay

18144 bronze badges

1 Answer
1

active

oldest

votes

3

You will need to use SQL Server 2008 R2 Enterprise Edition media to perform the in-place edition upgrade. I am unaware of any option available that allows you to perform an edition upgrade without a version upgrade when using media from a different SQL Server version.

Will your licensing agreement cover this? That wholly depends on your licensing (though I highly suspect it won't), but that question is best sent to your license partner/reseller.

If you have a MSDN license, you may still be able to pull down the binaries for SQL Server 2008 R2, so that would be one way to get the required media.

share|improve this answer

answered 6 hours ago

John EisbrenerJohn Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes. IIRC current versions of SQL Server use a unified installer across editions, but older versions did not.
  
  – David Browne - Microsoft
  5 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks David. Our thought was that running SQL Server Installation Center and choosing <Maintenance><Edition Upgrade> might work since the basic bits are probably the same between editions. My guess is that the only differences are some run-time switches, configuration values, etc. so the media might not be required.
  
  – Ray
  5 hours ago
  

  
  
  
  

add a comment | 

Your Answer

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "182"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f242772%2fsql2008r2-edition-upgrade%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

3

You will need to use SQL Server 2008 R2 Enterprise Edition media to perform the in-place edition upgrade. I am unaware of any option available that allows you to perform an edition upgrade without a version upgrade when using media from a different SQL Server version.

Will your licensing agreement cover this? That wholly depends on your licensing (though I highly suspect it won't), but that question is best sent to your license partner/reseller.

If you have a MSDN license, you may still be able to pull down the binaries for SQL Server 2008 R2, so that would be one way to get the required media.

share|improve this answer

answered 6 hours ago

John EisbrenerJohn Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes. IIRC current versions of SQL Server use a unified installer across editions, but older versions did not.
  
  – David Browne - Microsoft
  5 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks David. Our thought was that running SQL Server Installation Center and choosing <Maintenance><Edition Upgrade> might work since the basic bits are probably the same between editions. My guess is that the only differences are some run-time switches, configuration values, etc. so the media might not be required.
  
  – Ray
  5 hours ago
  

  
  
  
  

add a comment | 

3

You will need to use SQL Server 2008 R2 Enterprise Edition media to perform the in-place edition upgrade. I am unaware of any option available that allows you to perform an edition upgrade without a version upgrade when using media from a different SQL Server version.

Will your licensing agreement cover this? That wholly depends on your licensing (though I highly suspect it won't), but that question is best sent to your license partner/reseller.

If you have a MSDN license, you may still be able to pull down the binaries for SQL Server 2008 R2, so that would be one way to get the required media.

share|improve this answer

answered 6 hours ago

John EisbrenerJohn Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Yes. IIRC current versions of SQL Server use a unified installer across editions, but older versions did not.
  
  – David Browne - Microsoft
  5 hours ago
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Thanks David. Our thought was that running SQL Server Installation Center and choosing <Maintenance><Edition Upgrade> might work since the basic bits are probably the same between editions. My guess is that the only differences are some run-time switches, configuration values, etc. so the media might not be required.
  
  – Ray
  5 hours ago
  

  
  
  
  

add a comment | 

You will need to use SQL Server 2008 R2 Enterprise Edition media to perform the in-place edition upgrade. I am unaware of any option available that allows you to perform an edition upgrade without a version upgrade when using media from a different SQL Server version.

Will your licensing agreement cover this? That wholly depends on your licensing (though I highly suspect it won't), but that question is best sent to your license partner/reseller.

If you have a MSDN license, you may still be able to pull down the binaries for SQL Server 2008 R2, so that would be one way to get the required media.

share|improve this answer

answered 6 hours ago

John EisbrenerJohn Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

share|improve this answer

answered 6 hours ago

John EisbrenerJohn Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

answered 6 hours ago

John EisbrenerJohn Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges

answered 6 hours ago

John EisbrenerJohn Eisbrener

5,95822 gold badges1515 silver badges4343 bronze badges