When you are developing for the Microsoft Business Intelligence stack, you always needed Visual Studio for your business intelligence (SSIS, SSAS & SSRS) projects. If you have a full blown Visual Studio installation, you needed the BI templates; if you didn’t have Visual Studio (or the right version), you would install a shell that could only be used to develop BI projects.
So far so good, until the notorious marketing department of Microsoft decided to fiddle with the names of said software product. Over 2 years ago, I wrote the blog post SQL 2014 CTP1, where is my BIDS? – one of my most popular posts I might add – where I tried to explain the confusion of yet another name change and also point out how you could get the software. At that point in time – the CTP release of SQL Server 2014 – you had to download the software separately (it was no longer part of the SQL Server set-up) and you had to install it as “a new instance”. Anyway, in this blog post I’ll revisit the subject since there is again (some sort of) a name change.
Let’s give an overview of the SSDT evolution:
- BIDS or Business Intelligence Development Studio. The most non-confusing name of the bunch. This piece of software was delivered to you when you installed SQL Server 2005, SQL Server 2008 or SQL Server 2008 R2.
- SSDT or SQL Server Data Tools. Introduced with SQL Server 2012. However, you have a tool with the same name for creating database projects, which you had to download and install separately (don’t get me started on which names this tool had before. Mildly schizophrenic to say the least.) This development environment uses the Visual Studio 2010 shell and you use it to build BI solutions solely for SQL Server 2012. So two tools with the same name. One for database projects, one for BI projects. One to download, one that came with the SQL Server install media. Enter confusion. Read more about it on the blog of Jamie Thomson (blog | twitter): More SSDT naming confusion. Also read his blog posts about the database project part of SSDT, they are mighty interesting.
- SSDT-BI or SQL Server Data Tools – Business Intelligence. In an effort to swiftly put a stop to all this confusion, SSDT-BI was released with Visual Studio 2012. It’s basically still BIDS – or SSDT from the SQL Server installation media – but now with BI appended to make its purpose more clear. This environment uses the Visual Studio 2012 shell obviously, but is still used to create BI solutions for SQL Server 2012. Great deal of fun when you have two developers on the same project: one with SSDT (Visual Studio 2010) and one with SSDT-BI (Visual Studio 2012). In SQL Server 2014, you also had SSDT-BI as a separate download but for Visual Studio 2013.
- SSDT or SQL Server Data Tools. And we’re back in 2012. But this time, there are no two separate products but rather two products combined into one. This release combines the BI templates with the database projects part. And it’s still a separate download. At the moment of writing, only SSIS is supported however, but since it is still in preview you can expect this to change quickly. SSRS and SSAS will be added soon I hope. More information can be found here.
To be honest, I think the latest change is great since it has the least amount of confusion. There is now only one installer and you have everything you need. Combine this with the fact that in the future you would only need one version of Visual Studio to manage different versions of SQL Server (which has been announced, but not released yet) and we can admit that Microsoft has finally got it right. At least for the BI development environment that is.