ssdt_用于商业智能开发SQL Server数据工具（SSDT）的演变

ssdt

By all accounts, the introduction of SQL Server Data Tools (SSDT) in SQL Server 2012 was a watershed moment for many SQL Server developers. 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. package vs project deployments), simplified Tabular Model development, and also introduced us to the SSISDB. 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). 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. 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.

众所周知，SQL Server 2012中SQL Server数据工具（SSDT）的引入是许多SQL Server开发人员的分水岭。 不管是好是坏，SSDT作为用于商务智能开发的IDE，改变了我们部署SSIS程序包（即程序包与项目的部署），简化表格格式开发的方式，并向我们介绍了SSISDB。 同样，用SSDT取代Business Intelligence Development Studio（BIDS）的反对者显然不满意，除了安装SQL Server 2012外，您还必须单独下载和安装SSDT的BI模板（以前是BI模板）安装SQL Server 2005/2008以后，BIDS中的Windows就可以使用。 尽管SSDT-BI仍作为单独的安装提供，但SSDT的后续发行版中包含一些增强功能更改，应该在赢得批评家的心中大有帮助。 在本文中，我们对SSDT的所有版本（直到16.5）进行了比较分析，并确定了BI模板中引入的所有主要改进。

适用于Visual Studio 2010的SSDT (SSDT for Visual Studio 2010)

The focus of the initial release of SSDT was designed to replace BIDS as well as VSDB, as shown in Table 1.

如表1所示，SSDT初始版本的重点是取代BIDS和VSDB。

Old Tools	New Tools
Business Intelligence Development Studio (BIDS)	SQL Server Data Tools – Business Intelligence (SSDT-BI)
Visual Studio for Database Professionals (VSDB)	SSDT for SQL/Azure Database Development

旧工具	新工具
商业智能开发工作室（BIDS）	SQL Server数据工具–商业智能（SSDT-BI）