以前版本的 SQL Server Data Tools(SSDT 和 SSDT-BI)Previous releases of SQL Server Data Tools (SSDT and SSDT-BI)

适用对象:yesSQL ServeryesAzure SQL 数据库yesAzure SQL 数据仓库yes并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

SQL Server Data Tools (SSDT) 为生成 SQL Server 内容类型(关系数据库、Analysis Services 模型、Reporting Services 报表和 Integration Services 包)提供项目模板和设计图面。SQL Server Data Tools (SSDT) provides project templates and design surfaces for building SQL Server content types - relational databases, Analysis Services models, Reporting Services reports, and Integration Services packages.

SSDT 可向后兼容,因此用户始终都可以使用最新的 SSDT 来设计和部署在较早版本 SQL Server 上运行的数据库、模型、报表和包。SSDT is backwards compatible, so you can always use the newest SSDT to design and deploy databases, models, reports, and packages that run on older versions of SQL Server.

备注

以前,用于创建 SQL Server 内容类型的 Visual Studio shell 在各种不同的名称下发布,包括“SQL Server Data Tools” 、“SQL Server Data Tools-Business Intelligence” 和“Business Intelligence Development Studio” 。Historically, the Visual Studio shell used to create SQL Server content types has been released under various names, including SQL Server Data Tools, SQL Server Data Tools - Business Intelligence, and Business Intelligence Development Studio. 以前的版本附带多组不同的项目模板。Previous versions came with distinct sets of project templates. 若要在一个 SSDT 中同时获取全部项目模板,你需要 最新版本To get all of the project templates together in one SSDT, you need the newest version. 否则,你可能需要安装多个以前的版本才可获取 SQL Server 中使用的全部模板。Otherwise, you will probably need to install multiple previous versions to get all of the templates used in SQL Server. 每个 Visual Studio 版本只会安装一个 shell;安装另一个 SSDT 只会添加缺少的模板。Only one shell is installed per version of Visual Studio; installing a second SSDT just adds the missing templates.

最近下载Recent downloads

所提供的最近的下载针对的是不太可能在最新版本中遇到的问题。The last few downloads are provided for the unlikely event that you experience issues with the latest release.

SSDT 版本SSDT release Visual Studio 2017Visual Studio 2017
15.9.015.9.0 SSDT for VS2017 15.9.0SSDT for VS2017 15.9.0
15.8.215.8.2 SSDT for VS2017 15.8.2SSDT for VS2017 15.8.2
15.8.015.8.0 SSDT for VS2017 15.8.0SSDT for VS2017 15.8.0
15.7.115.7.1 SSDT for VS2017 15.7.1SSDT for VS2017 15.7.1
15.7.015.7.0 SSDT for VS2017 15.7.0SSDT for VS2017 15.7.0
15.6.015.6.0 SSDT for VS2017 15.6.0SSDT for VS2017 15.6.0

SSDT 版本SSDT release Visual Studio 2015Visual Studio 2015
17.417.4 SSDT for VS2015 17.4SSDT for VS2015 17.4
17.317.3 SSDT for VS2015 17.3SSDT for VS2015 17.3
16.516.5 SSDT for VS2015 16.5SSDT for VS2015 16.5

SSDT 版本SSDT release Visual Studio 2013Visual Studio 2013
16.516.5 SSDT for VS2013 16.5SSDT for VS2013 16.5

* SSDT支持两个最新版本的 Visual Studio。* SSDT supports the two most recent versions of Visual Studio. 随着 Visual Studio 2017 的发布,将不再更新 SSDT for VS2013。With the release of Visual Studio 2017, SSDT for VS2013 is no longer being updated. 有关其他信息,请参阅此 SSDT 团队博客文章的“常见问题解答”部分。For additional information, see the FAQ section of this SSDT team blog post.

SQL 关系:数据库引擎SQL Relational: Database Engine

提供模板,用于为 RDBMS 和 Azure SQL 数据库生成关系数据库。Provides templates for building relational databases for the RDBMS and Azure SQL Database. 对于设计关系数据库,SSDT 与版本无关。SSDT is version agnostic with respect to relational database design. 你可以将 Visual Studio 2012 或 2013 与任意版本的 SQL Server 数据库引擎或 Azure SQL 数据库一起使用。You can use either the Visual Studio 2012 or 2013 version with any version of SQL Server Database Engine or Azure SQL Database.

数据库设计器Database Designers

Visual Studio 2013 客户可以下载预览版本的 SSDT,以试用产品发布版本中尚未包括的新功能。Visual Studio 2013 customers can download a preview version of SSDT to try out new features that are not yet in the product release version.

SQL BI:Analysis Services、Reporting Services、集成服务SQL BI: Analysis Services, Reporting Services, Integration services

BI 模板用于创建 SSAS 模型、SSRS 报表和 SSIS 包。BI templates are used to create SSAS models, SSRS reports, and SSIS packages. BI Designer 与特定版本的 SQL Server 关联。BI Designers are tied to specific releases of SQL Server. 若要使用较新的 BI 功能,请安装较新版本的 BI Designer。To use the newer BI features, install a newer versioned BI designer.

BI DesignerBI Designers

下载 SSDT-BI for Visual Studio 2013(SQL Server 2014、SQL Server 2012、SQL Server 2008 和 2008 R2)Download SSDT-BI for Visual Studio 2013 (SQL Server 2014, SQL Server 2012, SQL Server 2008, and 2008 R2)

下载 SSDT-BI for Visual Studio 2012(SQL Server 2014、SQL Server 2012、SQL Server 2008 和 2008 R2)Download SSDT-BI for Visual Studio 2012 (SQL Server 2014, SQL Server 2012, SQL Server 2008, and 2008 R2

Business Intelligence Development Studio (BIDS) 通过 SQL Server 安装程序进行安装。Business Intelligence Development Studio (BIDS) is installed via SQL Server Setup. 没有 Web 下载。There is no web download. (SQL Server 2008 和 2008 R2)(SQL Server 2008, and 2008 R2)

对于 SQL Server 2012 或 2014,你可以使用“” SSDT-BI f或“” Visual Studio 2012 或“” SSDT-BI f或“” Visual Studio 2013For SQL Server 2012 or 2014, you can use either SSDT-BI for Visual Studio 2012 or SSDT-BI for Visual Studio 2013. 两者之间唯一的区别在于 Visual Studio 的版本。The only difference between the two is the Visual Studio version.

另请参阅See Also

下载 SQL Server Data Tools (SSDT)Download SQL Server Data Tools (SSDT)
下载 SQL Server Management Studio (SSMS)Download SQL Server Management Studio (SSMS)
SQL 工具和实用工具SQL Tools and Utilities