Evaluation edition is expired

Question

Post reply

Evaluation edition is expired

Ryan007

SSCrazy Eights

Points: 8275
More actions
August 22, 2011 at 6:09 am

#256108

Hi,
SQL server 2008 evaluation edition is expired in one of the server. I want to upgrade it to standard edition.
Do I need to uninstall SQL server evautaion edition or can I upgrade directly?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 1

Uninstall.

SQL Server 2008 (32-bit, x64 and IA64) Evaluation

No Upgrade Support

http://msdn.microsoft.com/en-us/library/ms143393.aspx

Grant Fritchey SSC Guru Points: 398913 More actions · Answer 2

Absolutely. Uninstall.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 3

According to this link, all of the following upgrades are supported for both x86 and x64:

http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.100).aspx

From:

SQL Server 2008 Enterprise Evaluation

To:

SQL Server 2008 Web

SQL Server 2008 Workgroup

SQL Server 2008 Standard

SQL Server 2008 Developer

SQL Server 2008 Enterprise

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Michael Valentine Jones (8/22/2011)
According to this link, all of the following upgrades are supported for both x86 and x64:
http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.100).aspx
From:
SQL Server 2008 Enterprise Evaluation
To:
SQL Server 2008 Web
SQL Server 2008 Workgroup
SQL Server 2008 Standard
SQL Server 2008 Developer
SQL Server 2008 Enterprise

It's nice to see the same link contradict itself! Unless I misunderstood what was being said ;-).

skrilla99 SSCertifiable Points: 5795 More actions · Answer 5

Interesting.

I would have thought there were no direct upgrade path from eval to anything else.

But, it looks like this has been supported since 2005. I suppose a test run is in order...

-Dan

skrilla99 SSCertifiable Points: 5795 More actions · Answer 6

Assuming it is supported, is there any glaring reason not to do it?

Code base for Eval should be the same as full release, right? With just a license restriction?

-Dan

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

skrilla99 (8/22/2011)
Assuming it is supported, is there any glaring reason not to do it?
Code base for Eval should be the same as full release, right? With just a license restriction?
-Dan

I'd still backup all the dbs first... and the vm to if possible.

jerry-621596 SSCertifiable Points: 6096 More actions · Answer 8

Eval editions have typically been hard coded with the "time bomb" code. For every eval edition I have ever used, including SQL Server, uninstall before installing a live version was required.

I my humble opinion, you should backup all of your databases and unintall before installing the live version. it may take a little longer than trying a direct upgrade path but you can be 100% sure that it will work the first time.

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 9

Ninja's_RGR'us (8/22/2011)
Michael Valentine Jones (8/22/2011)
According to this link, all of the following upgrades are supported for both x86 and x64:
http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.100).aspx
From:
SQL Server 2008 Enterprise Evaluation
To:
SQL Server 2008 Web
SQL Server 2008 Workgroup
SQL Server 2008 Standard
SQL Server 2008 Developer
SQL Server 2008 Enterprise
It's nice to see the same link contradict itself! Unless I misunderstood what was being said ;-).

I selected the 2008 page from the drop down list, instead of the 2008 R2 page, so my link is different than the one you posted.

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 10

Michael Valentine Jones (8/23/2011)
Ninja's_RGR'us (8/22/2011)
Michael Valentine Jones (8/22/2011)
According to this link, all of the following upgrades are supported for both x86 and x64:
http://msdn.microsoft.com/en-us/library/ms143393(v=SQL.100).aspx
From:
SQL Server 2008 Enterprise Evaluation
To:
SQL Server 2008 Web
SQL Server 2008 Workgroup
SQL Server 2008 Standard
SQL Server 2008 Developer
SQL Server 2008 Enterprise
It's nice to see the same link contradict itself! Unless I misunderstood what was being said ;-).
I selected the 2008 page from the drop down list, instead of the 2008 R2 page, so my link is different than the one you posted.

Nothing mouch different between

en-us/library/ms143393.aspx

and

en-us/library/ms143393(v=SQL.100).aspx

AFAIK I read the correct part of the document.

Anywho :w00t:

mister.magoo SSC-Forever Points: 47174 More actions · Answer 11

I have definitely done a SQL2008 Enterprise Evaluation SKU upgrade (on a test system) - I think it was to SQL2008 Standard edition.

It was a simple process using the SKUUPGRADE command line parameter.

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);