up vote 0 down vote favorite
share [g+] share [fb]

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.

link|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
feedback

2 Answers

up vote 1 down vote

  • 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.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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