SSDT - if I weren't already bald I'd tear my hair out.

Question

SSDT - if I weren't already bald I'd tear my hair out.

Kurt Wimberger

SSC Veteran

Points: 236
More actions
September 1, 2016 at 9:09 am

#312670

All - I am begging for a simple answer. I have been combing through the forums, and doing a serious amount of Googling, and am still confused regarding what versions of SSDT/SQL Server/Visual Studio play well together. I have SQL Server 2012 and VS2013. I *can*, if needed, upgrade to VS2015.
I read that SSDT version SSDTBI_x86_ENU.exe, available from https://www.microsoft.com/en-us/download/confirmation.aspx?id=42313, will work with VS2013, but it is targeted for SS2014. I have read here (https://www.mssqltips.com/sqlservertip/4253/backwards-compatibility-in-sql-server-data-tools-for-integration-services/) that until the SS2016 release, no versions of SSDT are backward compatible, which would suggest that this version will NOT work with SS2012. Is that accurate?
And if I want the backward compatible version of SSDT, is there a way to get it separate from SS2016? Or am I stuck loading a copy (if I can even get one) of VS2010 back on my box just to edit SSIS packages for SS2012?
I really just want to do some useful work. I'd think MS would want that as well. Thanks in advance for any input.
Kurt

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99130 More actions · Answer 1

It is Visual Studio 2010 you're looking for for SQL Server 2012. As far as I know as well, VS is not backward, or forward, compatible with SSRS. No idea why that's Microsoft's stance on it, but it is.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Kurt Wimberger SSC Veteran Points: 236 More actions · Answer 2

Thanks. I guess it's back to VS2010 for me. 🙁

Thanks for the help.

Kurt

frederico_fonseca SSCoach Points: 16154 More actions · Answer 3

newer versions of VS are supposed to be backward compatible..

and at least with SSDT for VS 2015 on the Integration Services project properties there is a TargetServerVersion property that allows you to select from SQL Server 2012 to 2016 versions.

And just a note that you do not need to have VS2015 to use this SSDT - it is advisable but if not installed SSDT will install a shell version of it.

Kurt Wimberger SSC Veteran Points: 236 More actions · Answer 4

Frederico:

I thought the shell for VS2015 could only be loaded from the SS2016 install?

Kurt

frederico_fonseca SSCoach Points: 16154 More actions · Answer 5

look here https://msdn.microsoft.com/library/mt204009.aspx

Kurt Wimberger SSC Veteran Points: 236 More actions · Answer 6

Wow, this IS one of the pages I read through - but I have *obviously* misread it the first time. It seems to say the exact opposite of what I thought I had read.

Thanks for the smack on the head!