下载并安装 SQL Server Data Tools (SSDT) for Visual StudioDownload and install SQL Server Data Tools (SSDT) for Visual Studio

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

SQL Server Data Tools 是一款现代开发工具,用于生成 SQL Server 关系数据库、Azure SQL 数据库、Analysis Services (AS) 数据模型、Integration Services (IS) 包和 Reporting Services (RS) 报表。SQL Server Data Tools is a modern development tool for building SQL Server relational databases, Azure SQL databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. 使用 SSDT,你可以设计和部署任何 SQL Server 内容类型,就像在 Visual Studio 中开发应用程序一样轻松。With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.

SSDT for Visual Studio 2019 中的变化Changes in SSDT for Visual Studio 2019

随着 Visual Studio 2019 发布,启用 Analysis Services、Integration Services 和 Reporting Services 项目所需的功能已移到相应 Visual Studio 扩展中。With Visual Studio 2019, the required functionality to enable Analysis Services, Integration Services, and Reporting Services projects has moved into the respective Visual Studio extensions. 创建数据库项目的核心 SSDT 功能依然是 Visual Studio 不可或缺的组成部分(需要在安装过程中选择数据存储和处理工作负荷)。The core SSDT functionality to create Database Projects has remained integral to Visual Studio (you need to select the Data storage and processing workload during install). 不再需要独立 SSDT 安装。There is no more standalone SSDT installation required.

如果已有 Visual Studio 2019 许可证:If you already have a license to Visual Studio 2019:

  • 对于 SQL 数据库项目,为 Visual Studio 安装数据存储和处理工作负荷For SQL Database Projects, install the Data storage and Processing workload for Visual Studio
  • 对于 Analysis Services、Integration Services 或 Reporting Services 项目,从商城安装相应的一个或多个扩展For Analysis Services, Integration Services or Reporting Services projects, install the appropriate extension(s) from the marketplace

如果尚无 Visual Studio 2019 许可证:If you don’t already have a license to Visual Studio 2019:

SSDT for Visual Studio 2017 中的变化Changes in SSDT for Visual Studio 2017

自 Visual Studio 2017 起,创建数据库项目的功能已集成到 Visual Studio 安装中。Starting with Visual Studio 2017, the functionality of creating Database Projects has been integrated into the Visual Studio installation. 无需安装 SSDT 独立安装程序,即可获得核心 SSDT 体验。There is no need to install the SSDT standalone installer for the core SSDT experience. 若要创建 Integration Services/Analysis Services/Reporting Services 项目,仍需要 SSDT 独立安装程序。To create Integration Services/Analysis Services/Reporting Services projects you still need the SSDT standalone installer.

  • 对于数据库项目,为 Visual Studio 安装数据存储和处理工作负荷For Database Projects, install the Data Storage and Processing workload for Visual Studio
  • 对于 Analysis Services、Integration Services 或 Reporting Services 项目,下载并安装 SQL Server Data ToolsFor Analysis Services, Integration Services or Reporting Services projects, download and install SQL Server Data Tools

使用 Visual Studio 2017 安装 SSDTInstall SSDT with Visual Studio 2017

若要在 Visual Studio 安装过程中安装 SSDT,请选择“数据存储和处理”工作负荷,然后选择“SQL Server Data Tools”。To install SSDT during Visual Studio installation, select the Data storage and processing workload, and then select SQL Server Data Tools. 如果已安装 Visual Studio,则可以编辑工作负荷列表,使其包括 SSDT:![数据存储和处理工作负荷If Visual Studio is already installed, you can edit the list of workloads to include SSDT: Data storage and processing workload

安装 Analysis Services、Integration Services 和 Reporting Services 工具Install Analysis Services, Integration Services, and Reporting Services tools

若要安装 AS、IS 和 RS 项目支持,请运行 SSDT 独立安装程序To install AS, IS, and RS project support, run the SSDT standalone installer.

该安装程序列出了可将 SSDT 工具添加到其中的可用 Visual Studio 实例。The installer lists available Visual Studio instances to add the SSDT tools to. 如果未安装 Visual Studio,则选择“安装新的 SQL Server Data Tools 实例”可通过最低版本的 Visual Studio 安装 SSDT,但为获得最佳体验,建议通过最新版本的 Visual Studio 使用 SSDT。If Visual Studio is not installed, selecting Install a new SQL Server Data Tools instance installs SSDT with a minimal version of Visual Studio, but for the best experience we recommend using SSDT with the latest version of Visual Studio.

选择 AS、IS、RS

SSDT for VS 2017(独立安装程序)SSDT for VS 2017 (standalone installer)

[![d下载]ownload](../ssdt/media/download.png) 下载 SSDT for Visual Studio 2017 (15.9.0)Download SSDT for Visual Studio 2017 (15.9.0)](https://go.microsoft.com/fwlink/?linkid=2052454)

重要

  • 安装 SSDT for Visual Studio 2017 (15.9.0) 前,请卸载“Analysis Services 项目”和“Reporting Services 项目”扩展(如已安装),并关闭所有 VS 实例。Before installing SSDT for Visual Studio 2017 (15.9.0), uninstall Analysis Services Projects and Reporting Services Projects extensions if they are already installed, and close all VS instances.
  • 请将 SSDT for Visual Studio 2017 (15.8.0) 或先前版本用于设计包含 Teradata 源/目标的 SSIS 包。Please use SSDT for Visual Studio 2017 (15.8.0) or the previous versions for designing SSIS packages that contain Teradata Source/Destination. 15.8.0 版之后的 SSDT for Visual Studio 2017 版本无法设计包含 Attunity Teradata 源/目标的 SSIS 包。SSDT for Visual Studio 2017 after 15.8.0 can’t design SSIS packages that contain Teradata Source/Destination by Attunity.

版本信息Version Information

版本号:15.9.0Release number: 15.9.0
生成号:14.0.16186.0Build Number: 14.0.16186.0
发布日期:2019 年 1 月 28 日Release date: January 28, 2019

有关更改的完整列表,请参阅 SQL Server Data Tools (SSDT) 发行说明For a complete list of changes, see the Release notes for SQL Server Data Tools (SSDT).

SSDT for Visual Studio 2017 具有与 Visual Studio 相同的系统需求SSDT for Visual Studio 2017 has the same system requirements as Visual Studio.

支持的语言 - SSDT for VS 2017Available Languages - SSDT for VS 2017

此版本的 SSDT for VS 2017 可安装以下语言:This release of SSDT for VS 2017 can be installed in the following languages:

脱机安装Offline install

若要在未连接到 Internet 时安装 SSDT,请按照此部分中的步骤执行操作。To install SSDT when you're not connected to the internet follow the steps in this section. 有关详细信息,请参阅 创建 Visual Studio 2017 的网络安装For more information, see Create a network installation of Visual Studio 2017.

首先,在联机时完成以下步骤:First, complete the following steps while online:

  1. 下载 SSDT 独立安装程序Download the SSDT standalone installer.

  2. 下载 vs_sql.exeDownload vs_sql.exe.

  3. 仍联机时,执行以下命令之一以下载脱机安装所需的全部文件。While still online, execute one of the following commands to download all the files required for installing offline. 使用 --layout 选项是关键,它将下载脱机安装的实际文件。Using the --layout option is the key, it will download the actual files for the offline installation. <filepath> 替换为保存文件的实际布局路径。Replace <filepath> with the actual layouts path to save the files.

    A.a. 对于特定语言,请传递区域设置:vs_sql.exe --layout c:\<filepath> --lang en-us(一种语言为大约 1 GB)For a specific language, pass the locale: vs_sql.exe --layout c:\<filepath> --lang en-us (a single language is ~1GB)
    B.b. 对于所有语言,请省略 --lang 参数:vs_sql.exe --layout c:\<filepath>(所有语言均为大约 3.9 GB)。For all languages, omit the --lang argument: vs_sql.exe --layout c:\<filepath> (all languages are ~3.9GB).

  4. 执行 SSDT-Setup-ENU.exe /layout c:\<filepath>,将 SSDT 有效负载提取到下载 VS2017 文件的同一 <filepath> 位置。Execute SSDT-Setup-ENU.exe /layout c:\<filepath> to extract the SSDT payload into the same <filepath> location where the VS2017 files were downloaded. 此操作确保这两者中的所有文件均合并到单个布局文件夹中。This ensure that all files from both are combined into a single layouts folder.

完成上一步骤后,可以在脱机时完成以下操作:After completing the previous steps, the following can be done while offline:

  1. 运行 vs_setup.exe --NoWeb 以安装 VS2017 Shell 和 SQL Server 数据项目。Run vs_setup.exe --NoWeb to install the VS2017 Shell and SQL Server Data Project.

  2. 从布局文件夹运行 SSDT-Setup-ENU.exe /install 并选择 SSIS/SSRS/SSAS。From the layouts folder run SSDT-Setup-ENU.exe /install and select SSIS/SSRS/SSAS.

    • 或者,若要执行无人参与安装,请运行Or for an unattended installation, run SSDT-Setup-ENU.exe /INSTALLALL[:vsinstances] /passive

有关可用选项,请运行For available options, run SSDT-Setup-ENU.exe /help

备注

如果使用完整版本的 Visual Studio 2017,请仅为 SSDT 创建脱机文件夹,并从该新建文件夹运行 SSDT-Setup-ENU.exe(请勿将 SSDT 添加到另一个 Visual Studio 2017 脱机布局)。If using a full version of Visual Studio 2017, create an offline folder for SSDT only, and run SSDT-Setup-ENU.exe from this newly created folder (don't add SSDT to another Visual Studio 2017 offline layout). 如果将 SSDT 布局添加到现有 Visual Studio 脱机布局,则无法在其中创建必要的运行时 (.exe) 组件。If you add the SSDT layout to an existing Visual Studio offline layout the necessary runtime (.exe) components are not created there.

受支持的 SQL 版本Supported SQL versions

项目模板Project Templates 支持的 SQL 平台SQL Platforms Supported
关系数据库Relational databases SQL Server 2005* - SQL Server 2017SQL Server 2005* - SQL Server 2017
(使用适用于 Visual Studio 2017 的 SSDT 17.x 或 SSDT 来连接 Linux 上的 SQL Server(use SSDT 17.x or SSDT for Visual Studio 2017 to connect to SQL Server on Linux)

Azure SQL DatabaseAzure SQL Database

Azure SQL 数据仓库(仅支持查询;尚不支持数据库项目)Azure SQL Data Warehouse (supports queries only; database projects are not yet supported)

* SQL Server 2005 支持已停止提供,* SQL Server 2005 support is deprecated,

请转至官方支持的 SQL 版本please move to an officially supported SQL version
Analysis Services 模型Analysis Services models

Reporting Services 报表Reporting Services reports
SQL Server 2008 - SQL Server 2017SQL Server 2008 - SQL Server 2017
Integration Services 包Integration Services packages SQL Server 2012 - SQL Server 2019SQL Server 2012 - SQL Server 2019

DacFxDacFx

SSDT for Visual Studio 2015 和 SSDT for Visual Studio 2017 都使用 DacFx 17.4.1:下载数据层应用程序框架 (DacFx) 17.4.1SSDT for Visual Studio 2015, and SSDT for Visual Studio 2017 both use DacFx 17.4.1: Download Data-Tier Application Framework (DacFx) 17.4.1.

以前的版本Previous versions

若要下载并安装 SSDT for Visual Studio 2015 或较旧版本的 SSDT,请参阅以前版本的 SQL Server Data Tools(SSDT 和 SSDT-BI)To download and install SSDT for Visual Studio 2015, or an older version of SSDT, see Previous releases of SQL Server Data Tools (SSDT and SSDT-BI).

后续步骤Next steps

安装 SSDT 后,阅读这些教程,了解如何使用 SSDT 创建数据库、包、数据模型和报告:After installing SSDT, work through these tutorials to learn how to create databases, packages, data models, and reports using SSDT:

info_tip 获取帮助Get Help

另请参阅See Also

SSDT MSDN 论坛SSDT MSDN Forum
SSDT 团队博客SSDT Team Blog
DACFx API 参考DACFx API Reference
下载 SQL Server Management Studio (SSMS)Download SQL Server Management Studio (SSMS)