I often get asked about upgrading SQL Server 2008 Evaluation Edition to a retail edition such as Standard or Enterprise Edition. This is very well documented at the below SQL Server books online link:
How to: Upgrade to a Different Edition of SQL Server 2008 (Setup) http://msdn.microsoft.com/en-us/library/cc707783.aspx
Below are the main steps, using the Setup , edition upgrade wizard.
You can also perform the upgrade using command line option, see below SQL BOL topic.
Command Line option
Hope this can help save time in upgrading to retail editions of SQL Server from the evaluation edition.
Note: The Evaluation edition of SQL Server is based on the Enterprise Edition and thus it is recommended to upgrade to SQL Server 2008 Enterprise Edition so you can continue to enjoy the many capabilities such as Resource Governor, Database compression, Backup compression, Transparent Database encryption, etc.
Do you know how to find out what happens after entering a PID? Will we experience downtime? For how long?
Do you know where to buy such a PID. We have 8 days left of our evaluation and really need to sort this out now. Thx. Reply to msntommy at live dot se
tI am bit confused.We have applications running on sharepoint and sql is of standard edition.
CAn we upgrade to sql enterprise edition.Will it cause any effects to the applications.
okay thank you very much
I have VM running WindowXP and on it, SQL 2008 Enterprise Edition( product version is 10.0.16.xx) and SSRS is running. I installed as native mode. I want to know that can I upgrade to Window 2008 R2 Enterprise Edition from my current version. Do I need to buy license again or just update SP then it works?Please help me as I need to know it in short time and I can't find in Microsoft site. All mention is upgrade to 2012. Thanks Dude!!
I have run all the steps as listed and the edition upgrade rules page tells me I can't "upgrade" my system. I have passed the evaluation stage. I have a license for standard. I enter that license and it tells me it can't do the upgrade but it is available for downgrade. I have read an awful lot of stuff about trying to get rid of R2.
I originally had 2005 Express installed. Attempted to upgrade to 2008 R2 but installer said no components to upgrade. So I ran the upgrade to 2008 R2 Express and that worked fine. This is all on 64 bit. I tried doing a edition version upgrade from 2008
R2 Express to 2008 R2 Enterprise and the edition upgrade reports success, but when I run SELECT @@VERSION it still shows Express. I ran this query and it still showed Express. I did the edition version upgrade twice just to make sure but it never changes.
The original instance of course was named SQLEXP_SOMETHING and its still there of course. I do not really care about the instance name but as long as I can get it up to enterprise.
This is the query from SELECT @@VERSION:
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (Intel X86) Jun 17 2011 00:57:23 Copyright (c) Microsoft Corporation Express Edition on Windows NT 6.0 (Build 6002: Service Pack 2) (WOW64) (Hypervisor)
Any thoughts on why it is still showing up as express despite edition upgrade?
Did you maybe solve that problem? I have the same.
The problem is solved! Couldn't fight with upgrade and these instances anymore. :-) Stop SQL services, Unistal all SQL, clean folders from SQL folder in Program files, and instal new version! If someone has some more "simple" solution, let me know!
Thanks Buddy. It helpep..:)