Should I uninstall SQL Server 2005 Express after installing SQL Server 2008 Express? What about VWDE 2005 Express?

I was using Visual Web Developer Express 2005 along with MS SQL Server Express 2005 and MS SQL Management Studio Express 2005. I have now upgraded to VWDE 2008, MS SQL Server Express 2008, and SQL Mgmt Studio 2008 Express. I uninstalled Mgmt. Studio Express 2005, however, I still have MS SQL Server 2005 installed on my PC along with VWDE 2005.

It appears that there are a few of these MS SQL 2005 Express components still installed on my PC..... any reason to keep them installed.... do I need them?

Can I uninstall MS SQL Server 2005 Express now? VWDE 2008 automatically upgrades VWDE 2005 projects when you open them----any reason to keep it installed?

Can I get some people to weigh in on this who have made the jump like I have?..... I'm concerned that running the MS SQL 2005 Express and the 2008 side-by-side is not necessary for any reason and that the SQL services ( and my CPU) is being needlessly taxed by having them both installed. Thanks.....
LVL 4
jazjefAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cyberkiwiCommented:
Hi,

I share your concern about taxing CPU needlessly.  Even though the projects upgrade, it does not pull the existing SQL Server 2005 database to 2008.  If you need the databases from 2005, just detach them and attach them in 2008, they will automatically upgrade to 2008 - except the compability mode which you can set manually.

Apart from that, happy uninstalling.
0
jazjefAuthor Commented:
Thanks cyberkiwi:
The databases rolled over automatically on the upgrade; I received a question during install that asked me if I wanted to add them to 2008. Other than that it sounds as though that MSSQLE 2005 is doing nothing but eating CPU cycles underneath.....guess I'll try to remove it tomorrow after my Acronis True Image program runs tonight (bawk bawk bawk----Can you say 'chicken'?) :)
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> however, I still have MS SQL Server 2005 installed on my PC along with VWDE 2005.

Then you have installed it as a new instance and definitely not an Upgrade as you mentioned in your question.
Kindly confirm this by looking at services.msc for SQL Server services whether single or more SQL Server service is there..

>> It appears that there are a few of these MS SQL 2005 Express components still installed on my PC..... any reason to keep them installed.... do I need them?

If you have only one service in services.msc, then those are client components of SQL Server 2005 and can be removed / uninstalled out safely
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

jazjefAuthor Commented:
Very true. I did not 'upgrade'.... I installed as a new instance.

I'm not sure what you mean about checking services.msc.

Do you mean 'Services' under administrative tools? I have a 3rd party 'services manager' program running in my tray and 'SSIS(2005) Service' and 'SSIS(2008) Service' are listed individually if I go to  'options'>>'default services'
0
cyberkiwiCommented:
Hi jaz,

I am pretty sure using "upgrade" to refer to moving to a new tech is ok! Opinion anyway.
I think we understand each other correctly - it has been a long time so I don't remember the prompt. I would have manually detached and attached anyway if the prompt wasn't there.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> Do you mean 'Services' under administrative tools?

Yes or you can use SQL Server Configuration manager alternatively to view the list of SQL Server services installed in the machine.

And since you have both SQL Server 2005 and 2008, you can uninstall SQL Server 2005 Expres alone without any issues. Make sure you are not removing shared components of SQL Server 2005 which might cause problems otherwise.
0
jazjefAuthor Commented:
So far so good.... SQL Server 2005 has been removed and no issues have occurred. Next: Removal of VWDE 2005.... we'll see what happens.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.