April 22, 2016 at 4:16 am
Just as we're upgrading to SQL 2012, our corporate office is pushing VS 2015 to everyone in the company. Their notes say that 2012 solutions can be opened up in 2015, worked on, then opened up in 2012 because there is no upgrade path. They are, however, talking about programming solutions (as far as I can tell).
Has anyone opened up an SSIS solution in VS 2015 without it upgrading to SQL 2014 or 2016?
I want to make sure that everyone in our division who develops SSIS packages have the correct tools and since none of us have VS 2015, I can't test it. I also don't want VS 2012 / Data Tools 2012 to get overwritten until we know for sure.
April 22, 2016 at 4:57 am
Hi there,
For "SQL Server Data Tools – Business Intelligence for Visual Studio 2013 (SSDT BI)", it was declared that the SSIS solutions will ONLY work on SQL Server 2014 onwards.
Source: msdn.microsoft.com[/url]
I also tried it myself and indeed, any SSIS package in Design mode (on SSDT VS2013) fails to connect to a SQL 2012 database.
I couldn't find any updated reference regarding SSDT for VS2015, but I have a feeling they'll keep this limitation..
Sorry for not finding you an exact answer, but I hope it helps
Regards,
Roni.
April 22, 2016 at 5:16 am
roni.vered (4/22/2016)
Hi there,For "SQL Server Data Tools – Business Intelligence for Visual Studio 2013 (SSDT BI)", it was declared that the SSIS solutions will ONLY work on SQL Server 2014 onwards.
Source: msdn.microsoft.com[/url]
I also tried it myself and indeed, any SSIS package in Design mode (on SSDT VS2013) fails to connect to a SQL 2012 database.
I couldn't find any updated reference regarding SSDT for VS2015, but I have a feeling they'll keep this limitation..
Sorry for not finding you an exact answer, but I hope it helps
Regards,
Roni.
Thanks, Roni. That actually confirms my worry. I'll get with my boss so we can get an exception for a side-by-side install instead of an upgrade install.
April 22, 2016 at 1:23 pm
Installing Visual Studio 2015 does not prevent you from installing Sql Server Data Tools for visual studio 2012 or 2013 - you can have all 3 versions installed of SSDT as these install the Visual Studio Shell corresponding to their version if the corresponding full version of VS is not installed.
see https://msdn.microsoft.com/en-us/library/mt674919.aspx for older versions of SSDT/SSDT-BI
April 25, 2016 at 5:41 am
frederico_fonseca (4/22/2016)
Installing Visual Studio 2015 does not prevent you from installing Sql Server Data Tools for visual studio 2012 or 2013 - you can have all 3 versions installed of SSDT as these install the Visual Studio Shell corresponding to their version if the corresponding full version of VS is not installed.see https://msdn.microsoft.com/en-us/library/mt674919.aspx for older versions of SSDT/SSDT-BI
My worry was that our corporate office was going to go for an upgrade / overwrite push of the VS 2015 and all tools. I have confirmed with them that they will be installing side-by-side, so my worries are no longer around.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply