February 22, 2010 at 11:06 am
I have a client that wants to upgrade from SQL Server 2008 Workgroup edition (10.0.1600) to SQL Server 2008 Standard edition.
We have tried launching the executable using the following command
setup.exe skuupgrade=1
But when I click into the Upgrade from SQL 2000 or 2005 link I eventually get to the page to select features to upgrade and nothing is selectable.
Is upgrading editions possible for the same version of SQL Server? Or do i have to upgrade from 2000 or 2005 to the standard edition of 2008?
If it is possible, is this the right method for upgrading editions?
Thanks,
John A
February 24, 2010 at 12:16 am
You need to buy the license for the Edition that you want to upgrade to:
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 24, 2010 at 8:53 am
We have a licensed copy
February 24, 2010 at 8:58 am
Do you want me to try and find the procedure?
All that had found last night was that it was a relatively easy process.
I performed multiple Goggle searches and I had a hard time.
Maybe you will have better luck than I?
Regards,
WC
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 24, 2010 at 9:22 am
I've tried Googling the issue and reading MSDN articles on the upgrade process. There was no indication that it couldn't be upgraded and there was no information about others having the same problem that I found.
All that I get is a feature selection screen with no selectable features which doesn't seem to make any sense to me.
February 24, 2010 at 9:44 am
Yes, this one was a little bit of a hassle with respect to the search criteria that you have to specify to get the answer that you are looking for.
Unfortunately this is the best that I can do for now. I think that this should get you in the right direction.
I assume that you have a Test Server to experiment with?
I'm researching something at the moment and sort of have my hands tied. SOrry I could not be of more help to you at this time.
FAQ: Switching between SQL Server 2008 editions
There is an extra step that you need to take when upgrading from one edition of SQL Server 2008 to another, for example when upgrading from Express to Express with Tools. This extra step is called Edition Upgrade (sometimes SKU Upgrade) and the net result is that you have to run the install wizard twice when upgrading an existing instance to a different edition
Edition Upgrade is really just another trip through the install wizard in which you provide the Product Key for the new edition.
Version and Edition Upgrades
Upgrade from Supported upgrade path
SQL Server 2008 Workgroup 1SQL Server 2008 Standard
SQL Server 2008 WorkgroupSQL Server 2008 Enterprise
1 This SQL Server edition can be upgraded to SQL Server 2008 on the 32-bit subsystem (WOW64) of a 64-bit server.
http://msdn.microsoft.com/en-us/library/ms143393.aspx
Regards,
WC
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 24, 2010 at 4:18 pm
Unfortunately we didn't have too much time to play with so they wanted us to just re-install fresh.
Thank you for your assistance
- John
February 25, 2010 at 12:36 pm
I wish that I could have been more help to you.
I had an MSDN subscription but I only have 28 out of the 50 points needed for the Microsoft Partner Status.
I had the subscription but I disassociated with the organization (Total 52 points).
As a result I no longer have all of the SQL Server Editions, although I do not recall that the workgroup edition was included.
If I had authorized copies of the software perhaps I would have been able to help you.
Sorry you had to go through the hassle of started from scratch. Restoring the System Databases, etc... :w00t:
I believe that the edition & license information is stored in the registry. So if you have a legal copy & know what registry keys to change you are not violating a license agreement.
Regards,
WC
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
February 25, 2010 at 2:06 pm
Thank you for all of your assistance
John
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply