3

What are the differences between SSDT and SSDT- Business Intelligence?

I've installed SQL Server 2017 and then proceeded to download Business Intelligence Development Studio but found out that it was replaced by SSDT/SSDT-BI (don't know the difference if there's any).

Do I need just SSDT or SSDT-BI? I can only find SSDT-BI for Visual Studio 2012 and 2013, not for VS 2017 while SSDT for VS 2017 is available.

Will this create any problems since I'm working with SQL Server 2017?

I'm a complete beginner at all this and this is only for a uni project. Please keep answers as simple as possible. Thank you very much.

Jacob H
  • 2,455
  • 1
  • 12
  • 29
Fayçal Salhi
  • 61
  • 2
  • 9
  • If you have SQL Server 2017, you'll need to download SSDT 2017. There have been different names/versions over the years, for example, back in 2008, is was called BIDS (Business Intelligence Development Studio). It's just a name though, really. – Thom A Mar 18 '18 at 18:53
  • Possible duplicate of [SSDT, SSDT-BI confusion in backwards compatibility for different SQL version](https://stackoverflow.com/questions/48984800/ssdt-ssdt-bi-confusion-in-backwards-compatibility-for-different-sql-version) – Yahfoufi Dec 03 '18 at 10:46

2 Answers2

8

There is only SSDT nowadays, which includes support for SQL Server Database, SSRS, SSRS, and SSIS projects. The download links are here. The current SSDT version (15.5.2 as of this writing) allows you to target SQL Azure Database, SQL Server 2017, as well as older versions so you don't need multiple versions of SSDT installed.

SSDT will install a minimal Visual Studio shell if VS is not already installed. If you already have VS installed, those project types will be added to the existing installation.

EDIT:

With Visual Studio 2019, SSDT for SQL Server database projects remains intregrated into the VS 2019 installer. Select the Data Storage and processing workload during install and choose SQL Server Data Tools. However, SAS, SSIS, and SSRS SSDT projects are now moved to separate Visual Studio extensions. These extensions can be manged post install from within Visual Studio under Extensions-->Manage Exentsions.

Dan Guzman
  • 43,250
  • 3
  • 46
  • 71
4

Yeah, this got a lot of people confused. According to this link (VS2012 & VS2013 timeframe):

  • SSDT is for building databases ONLY i.e. only base functionality.
  • SSDT-BI is for building SSIS/SSAS/SSRS solutions

But then it looks like from VS2015 onward they merged the two together into just SSDT, so after VS2013 there is no separate SSDT-BI install. I think.

Gary Barrett
  • 1,764
  • 5
  • 21
  • 33