February 23, 2017 at 5:48 pm
Hi I have most of my servers are at version SQL 2014. But I do have a couple of new SQL 2016 instances.
I would like to install SSMS 2016 on my workstation, but I still want to keep my SSMS 2014 version.
Is that possible to have both versions of the SQL server management studio exist and work on the computer?
February 23, 2017 at 7:39 pm
Yes you can, but why would you keep SSMS 2014, any specific reason?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
February 23, 2017 at 7:54 pm
Because most of my servers are still 2014, and If in ssms 2016 I modify a maintenance plan created using Ssms 2014 then it upgraded to 2016 version.
Next time I cannot use Ssms2014 to modify it more. And also for other small Dba tasks I found it is always best option using Ssms same version as server version.
February 24, 2017 at 10:36 am
Another reason to keep old versions would be if you have to work with SSIS packages, such as migrating them between servers. You can't connect to a previous SQL versions SSIS with a newer version of SSMS (which is why I've got SSMS 2008 R2, 2012, and 2014)
February 28, 2017 at 6:36 am
This may have been fixed in later releases, but a couple of months ago I couldn't see the database mirroring monitor through SSMS 2016, so sometimes you do need a couple of different ones.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply