下載並安裝 SQL Server Data Tools (SSDT) for Visual StudioDownload and install SQL Server Data Tools (SSDT) for Visual Studio

適用於: 是SQL Server 是Azure SQL Database 是Azure SQL 資料倉儲 是平行處理資料倉儲 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.

適用於 Visual Studio 2019 的 SSDT 中的變更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 Database 專案,請安裝適用於 Visual Studio 的「資料儲存和處理」工作負載For SQL Database Projects, install the Data storage and Processing workload for Visual Studio
  • 如需 Analysis Services、Integration Services 或 Reporting Services 專案,請從 Marketplace 安裝適當的擴充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:

適用於 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 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,請選取 [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,您可以編輯工作負載清單來包含 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,請選取 [Install a new SQL Server Data Tools instance] (安裝新的 SQL Server Data Tools 執行個體) 會以 Visual Studio 的最小版本安裝 SSDT,但若要獲得最佳體驗,建議搭配使用 SSDT 與 Visual Studio 的最新版本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)

下載 下載 SSDT for Visual Studio 2017 (15.9.1)download Download SSDT for Visual Studio 2017 (15.9.1)

重要

  • 如果已安裝「Analysis Services 專案」和「Reporting Services 專案」延伸模組,請先解除安裝,並關閉所有 VS 執行個體,然後安裝 SSDT for Visual Studio 2017 (15.9.1)。Before installing SSDT for Visual Studio 2017 (15.9.1), uninstall Analysis Services Projects and Reporting Services Projects extensions if they are already installed, and close all VS instances.
  • 請將適用於 Visual Studio 2017 的 SSDT (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 以後的適用於 Visual Studio 2017 的 SSDT無法設計包含 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.1Release number: 15.9.1
組建編號:14.0.16191.0Build Number: 14.0.16191.0
發行日期:2019 年 4 月 27 日Release date: April 27, 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.

可用語言 - 適用於 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:

離線安裝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 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 (一種語言 ~1GB)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.9GB)。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.

    • 若要自動安裝,請執行或 SSDT-Setup-ENU.exe /INSTALLALL[:vsinstances] /passiveOr for 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 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)