Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2008 Workgroup Edition Upgrade Expand / Collapse
Author
Message
Posted Monday, February 22, 2010 11:06 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:26 PM
Points: 342, Visits: 825
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
Post #870571
Posted Wednesday, February 24, 2010 12:16 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:14 PM
Points: 4,243, Visits: 4,291
You need to buy the license for the Edition that you want to upgrade to:

http://74.125.113.132/search?q=cache:rHKrZzC-ROQJ:download.microsoft.com/download/1/e/6/1e68f92c-f334-4517-b610-e4dee946ef91/2008%2520SQL%2520Licensing%2520Overview%2520final.docx+SQL+Server+2008+Workgroup+upgrade+to+the+Standard+or+Enterprise+edition&cd=8&hl=en&ct=clnk&gl=us


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/

Post #871748
Posted Wednesday, February 24, 2010 8:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:26 PM
Points: 342, Visits: 825
We have a licensed copy
Post #871973
Posted Wednesday, February 24, 2010 8:58 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:14 PM
Points: 4,243, Visits: 4,291
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/

Post #871977
Posted Wednesday, February 24, 2010 9:22 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:26 PM
Points: 342, Visits: 825
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.
Post #872001
Posted Wednesday, February 24, 2010 9:44 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:14 PM
Points: 4,243, Visits: 4,291
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.


http://blogs.msdn.com/sqlexpress/archive/2008/08/24/faq-switching-between-sql-server-2008-edtions.aspx


Version and Edition Upgrades

Upgrade from Supported upgrade path

SQL Server 2008 Workgroup 1 SQL Server 2008 Standard
SQL Server 2008 Workgroup SQL 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/

Post #872020
Posted Wednesday, February 24, 2010 4:18 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:26 PM
Points: 342, Visits: 825
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
Post #872370
Posted Thursday, February 25, 2010 12:36 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:14 PM
Points: 4,243, Visits: 4,291
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...


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/

Post #872949
Posted Thursday, February 25, 2010 2:06 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 12:26 PM
Points: 342, Visits: 825
Thank you for all of your assistance

John
Post #872998
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse