下載適用於 Visual Studio 的 SQL Server Data Tools (SSDT)Download SQL Server Data Tools (SSDT) for Visual Studio

適用於: SQL Server Azure SQL Database Azure Synapse Analytics 平行處理資料倉儲

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, databases in Azure SQL, 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.

適用於 Visual Studio 2019 的 SSDTSSDT for Visual Studio 2019

適用於 Visual Studio 2019 的 SSDT 中的變更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.

若要修改已安裝的 Visual Studio 工作負載以包含 SSDT,請使用 Visual Studio 安裝程式。To modify the installed Visual Studio workloads to include SSDT, use the Visual Studio Installer.

  1. 啟動 Visual Studio 安裝程式。Launch the Visual Studio Installer. 在 Windows [開始] 功能表中,您可搜尋「安裝程式」。In the Windows Start menu, you can search for "installer".

    2019 年 Windows [開始] 功能表中的 Visual Studio 安裝程式

  2. 在安裝程式中,選取所要新增 SSDT 的 Visual Studio 版本,然後選擇 [修改]。In the installer, select for the edition of Visual Studio that you want to add SSDT to, and then choose Modify.

  3. 在工作負載清單中選取位於 [資料儲存和處理] 下方的 [SQL Server Data Tools]。Select SQL Server Data Tools under Data storage and processing in the list of workloads.

    2019 年資料儲存及處理工作負載

針對 Analysis Services、Integration Services 或 Reporting Services 專案,請從 Visual Studio 內的 [延伸模組] > [管理延伸模組],或從 Marketplace 安裝適當的延伸模組For Analysis Services, Integration Services, or Reporting Services projects, you can install the appropriate extensions from within Visual Studio with Extensions > Manage Extensions or from the Marketplace.

適用於 Visual Studio 2017 的 SSDTSSDT for Visual Studio 2017

適用於 Visual Studio 2017 的 SSDT 中的變更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,請選取 [Data storage and processing] (資料儲存和處理) 工作負載,然後選取 [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,請使用 Visual Studio 安裝程式來修改已安裝的工作負載,以包含 SSDT。If Visual Studio is already installed, use the Visual Studio Installer to modify the installed workloads to include SSDT.

  1. 啟動 Visual Studio 安裝程式。Launch the Visual Studio Installer. 在 Windows [開始] 功能表中,您可搜尋「安裝程式」。In the Windows Start menu, you can search for "installer".

    2017 年 Windows [開始] 功能表中的 Visual Studio 安裝程式

  2. 在安裝程式中,選取所要新增 SSDT 的 Visual Studio 版本,然後選擇 [修改]。In the installer, select for the edition of Visual Studio that you want to add SSDT to, and then choose Modify.

  3. 在工作負載清單中選取位於 [資料儲存和處理] 下方的 [SQL Server Data Tools]。Select SQL Server Data Tools under Data storage and processing in the list of workloads.

    2017 年資料儲存及處理工作負載

安裝 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 執行個體] 以搭配 Visual Studio 的最小版本來安裝 SSDT,但若要獲得最佳體驗,則建議搭配 Visual Studio 的最新版本來使用 SSDT。If 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.8)

重要

版本資訊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.

可用語言 - 適用於 VS 2017 的 SSDTAvailable Languages - SSDT for VS 2017

這版 適用於 VS 2017 的 SSDT 提供下列語言版本: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

若要在未連線到網際網路時安裝 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 (一種語言 ~1 GB)。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.9 GB)。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
(使用 SSDT 17.x 或適用於 Visual Studio 2017 的 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 Synapse Analytics (僅支援查詢;尚不支援資料庫專案)Azure Synapse Analytics (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

Visual Studio 2015 與 2017 的 SSDT 都使用 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.

取得協助