SQL Server 2008 Workgroup Edition Upgrade

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL Server 2008 Workgroup Edition Upgrade

SQL Server 2008 Workgroup Edition Upgrade

Rate Topic

Display Mode

Topic Options

Author

Message

JohnnyDBA

Posted Monday, February 22, 2010 11:06 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:34 PM
Points: 334, Visits: 708

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

Welsh Corgi

Posted Wednesday, February 24, 2010 12:16 AM

Hall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052

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

JohnnyDBA

Posted Wednesday, February 24, 2010 8:53 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:34 PM
Points: 334, Visits: 708

We have a licensed copy

Post #871973

Welsh Corgi

Posted Wednesday, February 24, 2010 8:58 AM

Hall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052

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

JohnnyDBA

Posted Wednesday, February 24, 2010 9:22 AM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:34 PM
Points: 334, Visits: 708

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

Welsh Corgi

Posted Wednesday, February 24, 2010 9:44 AM

Hall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052

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

JohnnyDBA

Posted Wednesday, February 24, 2010 4:18 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:34 PM
Points: 334, Visits: 708

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

Welsh Corgi

Posted Thursday, February 25, 2010 12:36 PM

Hall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052

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/

Post #872949

JohnnyDBA

Posted Thursday, February 25, 2010 2:06 PM

Old Hand

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 2:34 PM
Points: 334, Visits: 708

Thank you for all of your assistance

John

Post #872998

« Prev Topic | Next Topic »

Permissions