Can a computer install multiple versions of SQL Server Management Studio ?
-
One computer can install multiple versions of Microsoft Visual Studio 2005, 2008, 2010, ... so SQL Server Management Studio can install multiple versions of 2005, 2008, ... the same computer ?
-
One computer can install multiple versions of Microsoft Visual Studio 2005, 2008, 2010, ... so SQL Server Management Studio can install multiple versions of 2005, 2008, ... the same computer ?
Yes
========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================
-
One computer can install multiple versions of Microsoft Visual Studio 2005, 2008, 2010, ... so SQL Server Management Studio can install multiple versions of 2005, 2008, ... the same computer ?
You can do it, but since the latest is able to manage any database, I would not recommend installing several versions. Just install the latest one and you will be able to manage any MS SQL database.
"I'm neither for nor against, on the contrary." John Middle
-
You can do it, but since the latest is able to manage any database, I would not recommend installing several versions. Just install the latest one and you will be able to manage any MS SQL database.
"I'm neither for nor against, on the contrary." John Middle
-
Doesn't the management studio also allow you to design solutions? Is that also backwards compatible in a way that one would feel comfortable deploying it?
SSMS will adapt itself to the version of the database it is connected to. Thus, you will not be able to setup something that would not be compatible with the database version you are working on. I've been using this software for years now, and never had to worry installing several versions on a single computer. That being said, you can easily test that latest version allows you to work on every database.
"I'm neither for nor against, on the contrary." John Middle
-
One computer can install multiple versions of Microsoft Visual Studio 2005, 2008, 2010, ... so SQL Server Management Studio can install multiple versions of 2005, 2008, ... the same computer ?
Yes, but I see no real need for multiple versions of SSMS in itself. That said, I still have the predecessors (SQL Enterprise Manager & SQL Query Analyzer, from SQL 2000) and its companion installed; I feel that Query Analyzer is a much lighter weight component for running queries I am open to new ideas, though; as I have been using the in-development SQL Operations Studio which is a little heavier than SQL-QA, but not as bloated as SSMS
Director of Transmogrification Services Shinobi of Query Language Master of Yoda Conditional