x

Can I run multiple versions of SSMS?

I have to connect to SQL Server 2008 and 2012. I have to design SSIS for 2008 only and have 2008 studio currently installed on my workstation.

Can I install SSMS 2012 and still develop SSIS packages for 2008? Any hints greatly appreciated.

more ▼

asked Sep 30, 2014 at 04:19 PM in Default

avatar image

dplaut
21 1 1 3

Are you sure you don't mean "Can I run multiple versions of BIDS?"

Oct 04, 2014 at 03:43 AM GPO
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Hi there, you can run SSMS (management studio) and connect to any SQL Server version. SSMS 2012 & 2014 as far as I am aware no longer need licences as long as you're connecting to a licensed server. So you would be best up upgrade SSMS for the improved environment.

However I think there is some confusion. You do not use SSMS for development of SSIS packages. In my environment we have 2008R2 and 2012. For SSIS I use BIDS 2008 and SSDT respectively. I do not believe that SSDT packages will deploy on a 2008/R2 environment.

Hope that helps.

more ▼

answered Oct 01, 2014 at 07:10 AM

avatar image

@SQLShark
3.9k 6 11 14

My concern is that installing SSMS 2008 installs BIDS. Not sure if installing a higher version of SSMS will install components that make SSIS packages developed in BIDS incompatible with SQL server 2008.

Oct 01, 2014 at 12:35 PM dplaut

If you install a newér version of bíds, make sure you don't open a ssis Project that has to be a previous version. The package will be converted and will not be compatible with previous version.

Oct 01, 2014 at 10:26 PM Håkan Winther

FWIW I'm currently running SSMS 2014 and SSMS 2008R2 side by side. I've noticed a few things that make me wary of uninstalling 2008R2 just yet. There are some formatting glitches in 2014 I've posted about earlier (SHIFT + TAB reformats certain code). 2014 Activity Monitor won't work connecting to older (SQL 2005 in 2000 compatibility) servers. There's a couple of other annoyances too. If I remember them I'll post back.

Oct 04, 2014 at 03:42 AM GPO
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x169
x23

asked: Sep 30, 2014 at 04:19 PM

Seen: 4029 times

Last Updated: Oct 04, 2014 at 03:43 AM

Copyright 2018 Redgate Software. Privacy Policy