Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Installing SQL Server 2008

Author  Topic 

groston
Yak Posting Veteran

61 Posts

Posted - 2010-02-11 : 19:35:07
I am loading software onto my new computer. I was surprised when I realized that Visual Studio 2008 Pro comes with SQL Server 2005 Express.

So, I am downloading SQL Server 2008 Developer and plan to install it. Couple of questions:
1: There are currently a pile of SQL Server items showing in the Add/Remove programs. They are: SQL Server 2005, Server 2008 Mgmt Objects, Server Compact 3.5 (three items), Database Publishing Wizard, Native Client, Setup support files, VSS writer. How many of these, if any, should I first uninstall before installing SQL Server 2008? I have no desire to run multiple versions of SQL.
2: Is there anything I will need to do, post installation, to ensure that SQL and Visual Studio will play nice together?

Thank you.

DaleTurley
Yak Posting Veteran

76 Posts

Posted - 2010-02-12 : 05:51:47
1)
Remove SQL Server 2005 - if you don't want the express version already installed.
SQL Server 2008 mgmt objects will get installed with the new 2008 install anyway so i'd leave them (they are for SMO in .Net i beleive)
SQL Server Compact may be worth leaving, it will alow you to open database files created in Visual Studio.
Database publishing wizard?? I've not seen that since Visual Studio 6.0 myself unless i';ve missed it...
Native Client i'd leave.
Setup support files could go, they'll get reinstalled with 2008 setup.
I beleive that the VSS writer will be removed by uninstalling SQL Server 2005...
Go to Top of Page
   

- Advertisement -