下载 SQL Server Data Tools (SSDT) for Visual StudioDownload SQL Server Data Tools (SSDT) for Visual Studio

适用于: 是SQL Server 是Azure SQL 数据库 是Azure Synapse Analytics(SQL 数据仓库)是并行数据仓库 APPLIES TO: YesSQL Server YesAzure SQL Database YesAzure Synapse Analytics (SQL Data Warehouse) YesParallel Data Warehouse

SQL Server Data Tools (SSDT) 是一款新式开发工具,用于生成 SQL Server 关系数据库、Azure SQL 数据库、Analysis Services (AS) 数据模型、Integration Services (IS) 包和 Reporting Services (RS) 报表 。SQL Server Data Tools (SSDT) 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 2019SSDT for Visual Studio 2019

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

用于创建数据库项目的核心 SSDT 功能一直是 Visual Studio 不可或缺的部分。The core SSDT functionality to create database projects has remained integral to Visual Studio.

随着 Visual Studio 2019 发布,启用 Analysis Services、Integration Services 和 Reporting Services 项目所需的功能仅移至相应 Visual Studio (VSIX) 扩展中。With Visual Studio 2019, the required functionality to enable Analysis Services, Integration Services, and Reporting Services projects has moved into the respective Visual Studio (VSIX) extensions only.

备注

没有适用于 Visual Studio 2019 的 SSDT 独立安装程序。There's no SSDT standalone installer for Visual Studio 2019.

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

如果已安装 Visual Studio 2019,则可以编辑工作负载列表,使其包括 SSDT。If Visual Studio 2019 is already installed, you can edit the list of workloads to include SSDT. 如果尚未安装 Visual Studio 2019,可以下载并安装 Visual Studio 2019 CommunityIf you don’t have Visual Studio 2019 installed, then you can download and install Visual Studio 2019 Community.

SSDT for Visual Studio 2017SSDT for Visual Studio 2017

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's no need to install the SSDT standalone installer for the core SSDT experience.

现在要创建 Analysis Services、Integration Services 或 Reporting Services 项目,仍需要 SSDT 独立安装程序。Now to create Analysis Services, Integration Services, or Reporting Services projects, you still need the SSDT standalone installer.

使用 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.

“数据存储和处理”工作负载

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

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

此安装程序列出了可用于添加 SSDT 工具的 Visual Studio 实例。The installer lists available Visual Studio instances to add SSDT tools. 如果尚未安装 Visual Studio,选择“安装新 SQL Server Data Tools 实例” 安装 SSDT 时使用的是最低版本 Visual Studio,但为了获得最佳体验,建议结合使用 SSDT 和最新版 Visual StudioIf Visual Studio isn't already 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)

“下载 SSDT for Visual Studio 2017 (15.9.5)”

重要

发行说明Release Notes

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

系统要求System requirements

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:

注意事项和限制Considerations and limitations

  • 无法脱机安装社区版You can’t install the community version offline

  • 若要升级 SSDT,需要遵循用于安装 SSDT 的相同路径。To upgrade SSDT, you need to follow the same path used to install SSDT. 例如,如果使用 VSIX 扩展添加了 SSDT,则必须通过 VSIX 扩展进行升级。For example, if you added SSDT using the VSIX extensions, then you must upgrade via the VSIX extensions. 如果通过单独安装来安装了 SSDT,需要使用这种方法进行升级。If you installed SSDT via a separate install, then you need to upgrade using that method.

脱机安装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 downloads the actual files for the offline installation. <filepath> 替换为保存文件的实际布局路径。Replace <filepath> with the actual layouts path to save the files.

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

完成上述步骤后,可以脱机 完成以下步骤:After completing the previous steps, the following steps below can be done 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. a.a. 若要执行无人参与安装,请运行 SSDT-Setup-ENU.exe /INSTALLALL[:vsinstances] /passiveFor an unattended installation, run SSDT-Setup-ENU.exe /INSTALLALL[:vsinstances] /passive.

有关可用选项,请运行 SSDT-Setup-ENU.exe /helpFor 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 aren't yet supported)

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

请迁移到官方支持的 SQL 版本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 和 2017 都使用 DacFx 17.4.1:下载数据层应用程序框架 (DacFx) 17.4.1SSDT for Visual Studio 2015 and 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).

另请参阅See Also

后续步骤Next steps

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

获取帮助