sql server business intelligence development studio 2016

For instance, for the first time ever we were introduced to the SSIS Toolbox window, and the SSIS (Integration Services) templates were enhanced to: Visual Studio for Database Professionals (VSDB)Īs shown in Figure 1, the initial release of SSDT ran off a Visual Studio 2010 Shell and there were no major changes to the templates that were last released as part of BIDS 2008 except for the inclusion of Analysis Services Tabular Project template.Īlthough the initial release of SSDT contained almost similar templates to BIDS 2008, it did however provide several enhancements to those templates. SQL Server Data Tools – Business Intelligence (SSDT-BI) The focus of the initial release of SSDT was designed to replace BIDS as well as VSDB, as shown in Table 1.īusiness Intelligence Development Studio (BIDS) In this article we conduct a comparative analysis of all versions (up until 16.5) of SSDT and identify all the major improvements that have been introduced in the BI templates. Although SSDT-BI is still being offered as a separate installation, subsequent releases of SSDT have included several enhancements changes that should go a long way to winning the hearts of its critics. Likewise the replacement of Business Intelligence Development Studio (BIDS) with SSDT had its detractors who were noticeably not very happy that in addition to installing SQL Server 2012 you still had to do a separate download and installation of BI templates for SSDT (previously, BI templates in BIDS were available as soon as you installed SQL Server 2005/2008). package vs project deployments), simplified Tabular Model development, and also introduced us to the SSISDB. For better or for worse, SSDT as an IDE for business intelligence development changed – amongst other things – the way we deployed our SSIS packages (i.e. By all accounts, the introduction of SQL Server Data Tools (SSDT) in SQL Server 2012 was a watershed moment for many SQL Server developers.

Sql server business intelligence development studio 2016