What version should I use?

Sep 3, 2015 at 4:56 PM
Brand new to BIDS. The download page says:

"BIDS Helper 2014 is for SQL 2014 and Visual Studio 2013.
BIDS Helper 2012 is for SQL 2012, Visual Studio 2010, and Visual Studio 2012."

I'm using SQL 2012 and Visual Studio 2013. Which BIDS version should I use?
Coordinator
Sep 3, 2015 at 8:39 PM
Microsoft only supports SQL Server Data Tools for Business Intelligence or SSDT-BI (which is what they've renamed BIDS to) for SQL 2012 in Visual Studio 2010 or 2012. So you'll need to also install one of those shell's as well. The install media for SQL Server 2012 comes with the Visual Studio 2010 shell.

The other option if you are only doing SSAS development might be to install the SQL 2014 tools. The SSAS designers have an option to target lower version servers. But the big problem is the SSIS designers you can't deploy SSIS 2014 projects to a 2012 server. So if you are likely to do any work with SSIS you'll need to install either the 2010 or 2012 VS shell (you only need the shell not the full VS install which is only 160Mb download)
Marked as answer by furmangg on 9/5/2015 at 4:11 AM
Sep 3, 2015 at 8:59 PM
Thanks for the reply! I meant to say "BIDS Helper" instead of BIDS in my original question -- I'm not new to BIDS itself. My organization already uses the full Visual Studio 2013 for a variety of purposes. I'm using SSDT-BI for Visual Studio 2013, and I haven't run into problems using that against a SQL 2012 database (although you're right, the download link says it's intended for SQL 2014). That may answer my question right there -- if that combination truly does work, then I probably want BIDS Helper 2014 (assuming it will similarly work with SQL 2012). I will primarily be doing SSIS development, though, so I'll test all this out thoroughly. Thanks for the caution about deploying a 2014 project to a 2012 server -- that may force me back to BIDS Helper 2012 and another Visual Studio shell.