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?
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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
 
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
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 & ArchitectCommented:
>> 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.