| title | Install SQL Server Data Tools (SSDT) | |||
|---|---|---|---|---|
| description | Learn about SQL Server Data Tools (SSDT). See how to install this database development tool set with Visual Studio 2019, 2022, and 2026. | |||
| author | dzsquared | |||
| ms.author | drskwier | |||
| ms.reviewer | randolphwest | |||
| ms.date | 02/06/2026 | |||
| ms.service | sql | |||
| ms.subservice | ssdt | |||
| ms.topic | install-set-up-deploy | |||
| ms.custom |
|
|||
| keywords |
|
|||
| monikerRange | >=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || =azuresqldb-mi-current || =fabric-sqldb |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance Synapse Analytics FabricSQLDB]
SQL Server Data Tools (SSDT) is a set of development tooling for building SQL Server databases, Azure SQL databases, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy SQL objects with the same project concept as other application development tools. The SQL projects capability extends to CI/CD pipelines, enabling you to automate the build and deployment of your database projects with the SqlPackage CLI.
The release notes for SSDT and its components are available for Visual Studio 2017, 2019, 2022, and 2026. An overview of the core SSDT functionality is provided in the SSDT Overview.
:::image type="content" source="media/download-sql-server-data-tools-ssdt/install-layout.png" alt-text="Screenshot of graphic with SQL Server Data Tools component and three extensions.":::
SSDT is installed as a Visual Studio component, both for online installation and offline installation. Analysis Services, Integration Services, and Reporting Services projects are available as separate extensions for each version.
Note
SDK-style SQL projects in Visual Studio are available as part of the SQL Server Data Tools, SDK-style (preview) feature for Visual Studio 2022, separate from the original SSDT. The SDK-style project format is based on the new SDK-style projects introduced in .NET Core and is the format used by the SQL Database Projects extension for Visual Studio Code. For more information, see SQL Server Data Tools, SDK-style (preview).
If Visual Studio 2026 or Visual Studio 2022 is already installed, you can edit the list of workloads to include SSDT. If you don't have Visual Studio 2022 or 2026 installed, then you can download and install Visual Studio 2026.
To modify the installed Visual Studio workloads to include SSDT, use the Visual Studio Installer.
-
Launch the Visual Studio Installer. In the Windows Start menu, you can search for "installer."
-
In the installer, select Modify for the version of Visual Studio to which you want to add SSDT.
-
Select SQL Server Data Tools under Data storage and processing in the list of workloads.
:::image type="content" source="media/download-sql-server-data-tools-ssdt/data-workload-2022.png" alt-text="Screenshot of Data storage and processing workload 2022." lightbox="media/download-sql-server-data-tools-ssdt/data-workload-2022.png":::
Visual Studio is available as a native Arm64 application on Windows 11 Arm64. In Visual Studio 2026, SSDT is available for Arm64 with some limitations:
- IntelliSense and code completion aren't available for T-SQL files in SQL projects
- The T-SQL debugger isn't available
- Visual Studio can't connect to LocalDB
To install or configure Visual Studio to include SSDT on an Arm64 device:
-
Install Visual Studio 2026 or later on your Arm64 device.
-
In the installer, select the Individual components tab and search for SQL Server Data Tools.
:::image type="content" source="media/download-sql-server-data-tools-ssdt/ssdt-component-install.png" alt-text="Screenshot of SQL Server Data Tools for Arm64." lightbox="media/download-sql-server-data-tools-ssdt/ssdt-component-install.png":::
-
Select SQL Server Data Tools and then choose Modify.
For Analysis Services (SSAS), Integration Services (SSIS), or Reporting Services (SSRS) projects, you can install the appropriate extensions from within Visual Studio with Extensions > Manage Extensions or from the Marketplace.
The extensions for Visual Studio 2022 and 2026 are shared:
The extensions for Visual Studio 2022 and 2026 are shared:
Extensions for Visual Studio 2019:
Supported SQL versions in Visual Studio 2026:
| Project templates | SQL platforms supported |
|---|---|
| Relational databases | [!INCLUDE sssql16-md] - [!INCLUDE sssql22-md] Azure SQL Database, Azure SQL Managed Instance Azure Synapse Analytics Dedicated Pools Azure Synapse Analytics Serverless Pools Warehouse in Microsoft Fabric SQL database in Microsoft Fabric |
| Analysis Services models Reporting Services reports |
[!INCLUDE sssql16-md] - [!INCLUDE sssql25-md] |
| Integration Services packages | [!INCLUDE sssql19-md] - [!INCLUDE sssql25-md] |
Supported SQL versions in Visual Studio 2022:
| Project templates | SQL platforms supported |
|---|---|
| Relational databases | [!INCLUDE sssql16-md] - [!INCLUDE sssql22-md] Azure SQL Database, Azure SQL Managed Instance Azure Synapse Analytics Dedicated Pools Azure Synapse Analytics Serverless Pools (requires VS2022 17.7) |
| Analysis Services models Reporting Services reports |
[!INCLUDE sssql16-md] - [!INCLUDE sssql22-md] |
| Integration Services packages | [!INCLUDE sssql19-md] - [!INCLUDE sssql22-md] |
Supported SQL versions in Visual Studio 2019:
| Project templates | SQL platforms supported |
|---|---|
| Relational databases | [!INCLUDE sssql11-md] - [!INCLUDE sssql19-md] Azure SQL Database, Azure SQL Managed Instance Azure Synapse Analytics (dedicated pools only) |
| Analysis Services models Reporting Services reports |
[!INCLUDE sql2008-md] - [!INCLUDE sssql19-md] |
| Integration Services packages | [!INCLUDE sssql11-md] - [!INCLUDE sssql22-md] |
For scenarios where offline installation is required, such as low bandwidth or isolated networks, SSDT is available for offline installation. Two approaches are available:
- For a single machine, Download All, then install
- For installation on one or more machines, use the Visual Studio bootstrapper from the command line
For more details, you can follow the Step-by-Step Guidelines for Offline Installation
To understand the license terms and use cases for Visual Studio, refer to Visual Studio License Directory. For example, if you're using the Community Edition of Visual Studio for SQL Server Data Tools, review the end user licensing agreement (EULA) for that specific edition of Visual Studio in the Visual Studio License Directory.
To download and install SSDT for Visual Studio 2017, or an older version of SSDT, see Previous releases of SQL Server Data Tools (SSDT and SSDT-BI).
- SSDT Team Blog
- DACFx API Reference
- SQL Database Projects extension
- What are SQL database projects?
- SSIS How to Create an ETL Package
- Analysis Services tutorials
- Create a basic table report (SSRS tutorial)
[!INCLUDE get-help-options]
