Update sql server 2005 standard to enterprise edition

Question

Update sql server 2005 standard to enterprise edition

Ed7

SSCrazy Eights

Points: 8519
More actions
June 22, 2007 at 8:55 am

#173113

Hi all sql guru,
I need to upgrade sql server 2005 standard edition to enterprise.
is that any best practice articles and links?
Thank you.
TJ

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic. Login to reply

bledu SSChampion Points: 12335 More actions · Answer 1

i don't know of any articles, but i reckon everything that was working in the standard edition should still be working in the enterprise.

Everything you can imagine is real.

Deepak-405225 SSCertifiable Points: 6120 More actions · Answer 2

Hi,

pls refer the below link,

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

[font="Verdana"]- Deepak[/font]

Marc van der Wielen SSC Journeyman Points: 97 More actions · Answer 3

Hi,

We justed upgraded to enterprise for one of our customers. A good advice is to prepare your upgrade by backing up all of your vital components (databases, as db's, r's db's, config files etc.). Fortunately we didn't need any of those. The only thing we needed was the setup.exe SKUUPGRADE=1 command from the command prompt. Wait for sometime, install service pack 2 and within two hours we were up and running again.

Good luck.

Marc

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 4

These links will be really useful for you.

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en

SQL Server 2005 upgrade manual. (This document can be used as a guide to proceed with the upgrade of SQL Server instance)

http://www.microsoft.com/technet/prodtechnol/sql/2005/sqlupgrd.mspx Upgrade handbook.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Rajesh Verma-480186 Valued Member Points: 71 More actions · Answer 5

Hi Marc,

We have a SQLServer 2005 Std edition instance with sp2. We would like to upgrade it to SQLServer 2005 Ent edition with sp2. It looks like you did the same for your customer. Could you answer these please :

1. Did you go to command prompt and being in main SQlServer 2005 Ent directory executed the "setup.exe SKUUPGRADE=1" command ?

2. Do you need to apply sp2 again even though you were on sp2 with Std. edition ?

3. Do you think that there would be same upgrade process if you were using 64 bit set up instead of 32 bit ? We actually have 64 bit install for this one.

Thanks a lot !!!

- Raj

info@kraaitje.nl Old Hand Points: 386 More actions · Answer 6

We also want to upgrade.

SQL 2005 Standard INCL. SP2 -> SQL 2005 Enterprise INCL. SP2

How can I proceed?

isd83 Ten Centuries Points: 1066 More actions · Answer 7

Has anyone tried the SKUUPGRADE=1 on upgrading sql 2005 cluster from standard edition to Enterprise edition? Any information would appreciated. Thanks.

henri flokstra SSC Eights! Points: 939 More actions · Answer 8

@kraaitje and edwin: are you gonna share your experiences with us??

------------------------------------------------------------
Application Architect and Developer @ Traffic4u
Visit my profile on LinkedIN

info@kraaitje.nl Old Hand Points: 386 More actions · Answer 9

We haven't done any upgrade yet but I'm investigating which steps we must take. When we've done the upgrade I would post the results on this forum.

schwizla SSCrazy Points: 2668 More actions · Answer 10

Just done this today.

I had to upgarde two instance SQL Standard SP2 --> SQL Enterprise SP2.

Just Run "setup.exe SKUUPGRADE=1" as explained above. Then I selected each instance name and wnet through the motions.

Worked a treat. You need to reinstall SP2 though.

Boris Goldshmit SSC Enthusiast Points: 148 More actions · Answer 11

Just out of curiosity, what prompted your companies to move up from standard to enterprie edition?

I am trying to convince a major client (3000+ users, very data-intensive business) to not try to save money on the Sql Server version and go directly to Enterprise, but the lack of technical sophistication and full grasp on the amount of processing that this business is going to generate stands in the way.

I need some serious arguments to generate some knee-jerk reaction and save them and us serious headache and potential problems in production.

Balmukund SSCertifiable Points: 6648 More actions · Answer 12

Standard to Entrerprise is completely supported

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

nitin.b.gupta Old Hand Points: 384 More actions · Answer 13

Pls refer.:)

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

David Kingman Say Hey Kid Points: 675 More actions · Answer 14

Hi,

I read the posts here and the MS articles and installed the upgrade adviser.

They don't seem to have any other alternative than in-place(not for 32bit-64bit upgrade) or side-by-side. The upgrade adviser is not intended for a 2005 Standard SP2 to 2005 EE upgrade apparently, it gave an error saying it doesn't do our version.

We have only one SQL Server 2005 server (running on a 32bit server) so side-by-side isn't going to work....will it?

It is my understanding that Windows Server 2003 needs to be reinstalled to run 64bit version of the OS, so are we stuck with "re"installing SQL 2005 Enterprise 64bit after the OS install. Any suggestions/resources on doing this type of upgrade?

We also are going from a two processor license to a one processor license, any info on this type of thing would be helpful.

Thanks,

DaveK