Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Upgrading SQL Server 2005


Upgrading SQL Server 2005

Author
Message
Site Owners
Site Owners
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10095 Visits: 1
Comments posted to this topic are about the item Upgrading SQL Server 2005
Vivien Xing
Vivien Xing
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1294 Visits: 2204
I doubt about the answer. Here is the link for discussion:
http://www.microsoft.com/sql/downloads/trial-system-requirements.mspx
“Upgrading and Uninstalling the Trial Software”
Matt Miller (#4)
Matt Miller (#4)
SSCertifiable
SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)SSCertifiable (7.6K reputation)

Group: General Forum Members
Points: 7643 Visits: 18084
I remembered reading that as well... Of course - it is worded as "strongly recommended that you uninstall and reinstall", so I suppose you upgrade directly.

Not having any direct experience at it - hard to say.

----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
jadsmith
jadsmith
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2780 Visits: 493
Assuming that the evaluation edition has not expired.



majorbloodnock
majorbloodnock
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1113 Visits: 3062
Although even in Vivien's link, the sentence before the "strong recommendation" states that it can be done. If MS send that out in their documentation, they have an obligation to stand by it.

That said, I agree that it's one of those upgrade paths that's fraught with unnecessary gotchas, so I doubt many people would follow it. When all's said and done, an evaluation is a form of test, so I can't personally think of any time when I'd let an evaluation edition of any software near any instance of mine that couldn't be blown away with impunity.

Semper in excretia, sumus solum profundum variat
Hugo Kornelis
Hugo Kornelis
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8329 Visits: 11580
Hi all,

Supporting frmo eval to any other edition is supported: http://msdn2.microsoft.com/en-us/library/ms143393.aspx

However, it only works BEFORE the evaluation period expires. After that, you'll have to uninstall the eval edition before instaling the paid edition: http://support.microsoft.com/kb/914158


Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
StarNamer
StarNamer
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1294 Visits: 1992
I got this right and have, in the past, upgraded a trial Exchange Server to full version, so I know it works for some MS software and assumed it would work for others.

Having said that, it's not that hard to do a backup-uninstall-install-restore sequence so I'd probably do that if I couldn't just wipe the system and start from scratch as it gets closest to clearing out everything. If the system is going to a full license then you should have a backup strategy in place so will be doing backups anyway, won't you? Wink

My preferred method would be backup-OSinstall-SQLinstall-restore with an implied 'wipe system' in the OSinstall as that makes sure that the final system doesn't have any trial software left on it.

Derek
Vivien Xing
Vivien Xing
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1294 Visits: 2204
Hugo’s link is more recent. So it can be a proof for the answer. The most important thing is MS supported.

I am afraid of doing so in a real production environment.
Maarten Takens
Maarten Takens
Mr or Mrs. 500
Mr or Mrs. 500 (518 reputation)Mr or Mrs. 500 (518 reputation)Mr or Mrs. 500 (518 reputation)Mr or Mrs. 500 (518 reputation)Mr or Mrs. 500 (518 reputation)Mr or Mrs. 500 (518 reputation)Mr or Mrs. 500 (518 reputation)Mr or Mrs. 500 (518 reputation)

Group: General Forum Members
Points: 518 Visits: 80
Upgrading from the Eval product to any other version might be supported by Microsoft ,but i would never recommend doing so ..
Jamie-2229
Jamie-2229
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2957 Visits: 831
http://blogs.msdn.com/sanchan/archive/2006/07/27/681086.aspx

"To perform an in-place upgrade of SQL 2005 Eval edition to other SQL Server 2005 full blown editions, simply run the setup and it will identify the existing installation, and will run an upgrade check. It will then let you know if the upgrade is possible or not. If the upgrade is possible, simply go through the setup wizard and it will automatically upgrade the already installed instance of eval edition."

The way the question is worded - you can upgrade to any and all... is dubiously worded. You cannot upgrade a SQL 2005 Evaluation to SQL 2000 or to SQL 7 or to SQL 6.5... or at least, I was unaware that it is possible.

Above quote goes on to say that you must uninstall after the product has expired in order to upgrade.

I am bothered that lately all the questions are worded such that there is never a correct answer. Is it intentional or am I only just now noticing? hmmmm...

Jamie
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search