Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

What is the difference between SQL2008 and SQL2008 R2?

Should I unintall SQL 2005 and install SQL 2008 Web Edition?

Or

Should I upgrade the SQL 2005 to SQL 2008 Web Edition?

I will also need to make sure the Logins are transferred over as many of my web applications have a Login on SQL2005 server.

share|improve this question
    
What are you trying to achieve? I tend to only upgrade due to support, security or functional benefits. –  Chopper3 May 13 '10 at 9:01
    
Upgrading to get the new features of SQL 2008. –  picflight May 13 '10 at 9:07
1  
But these are the same features you're not aware of right (i.e. your first quesion)> –  Chopper3 May 13 '10 at 9:32
1  
@Chopper3: Exactly. Voice 1: "Oooh, there's a new version, I better upgrade". Voice 2: "Why do you need to upgrade?". Voice 1: "Because it's new?". Upgrades should be undertaken for specific reasons: new features that are needed, security, functionality, end of life, end of support, etc. –  joeqwerty May 13 '10 at 12:31
    
@Joe, with you 100% - it's why I love virtualisation, I have a bunch of 'play' hosts on their own vlan that I can bugger-up a hundred times a day with no risk of killing anything else - THATS where I test new stuff, leaving production as undisturbed as possible. –  Chopper3 May 13 '10 at 13:06
add comment

2 Answers

  • Microsoft has a nice page with all new stuff. READ IT. I really love when people come here for question as complicaed as going through a one page HTML document. In any case, there i no reason to install 2008 if you do an upgrade anyway.

  • Try doing an in place upgrade. Definitely a lot less trouble than uninstall / reinstall, which will neede all the logins etc. recreated.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.