| title | Download 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 and Visual Studio 2017. |
| ms.prod | sql |
| ms.prod_service | sql-tools |
| ms.technology | ssdt |
| ms.topic | conceptual |
| keywords | install ssdt, download ssdt, latest ssdt |
| author | dzsquared |
| ms.author | drskwier |
| ms.reviewer | maghan |
| ms.custom | seo-lt-2019 |
| ms.date | 05/19/2022 |
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||=azuresqldb-mi-current |
[!INCLUDE sql-asdb-asa]
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. 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.
The core SSDT functionality to create database projects has remained integral to Visual Studio.
Note
There's no SSDT standalone installer for Visual Studio 2022.
If Visual Studio 2022 is already installed, you can edit the list of workloads to include SSDT. If you don’t have Visual Studio 2022 installed, then you can download and install Visual Studio 2022.
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 for the edition of Visual Studio that you want to add SSDT to, and then choose Modify.
-
Select SQL Server Data Tools under Data storage and processing in the list of workloads.
For Analysis Services or Reporting Services projects, you can install the appropriate extensions from within Visual Studio with Extensions > Manage Extensions or from the Marketplace.
The extension for Integration Services projects is not available for Visual Studio 2022 at this time.
| Project Templates | SQL Platforms Supported |
|---|---|
| Relational databases | [!INCLUDE sssql16-md] - [!INCLUDE sssql22-md] Azure SQL Database, Managed Instance Azure Synapse Analytics (dedicated pools only) |
| Analysis Services models Reporting Services reports |
SQL Server 2016 - SQL Server 2019 |
The core SSDT functionality to create database projects has remained integral to 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 (VSIX) extensions only.
Note
There's no SSDT standalone installer for Visual Studio 2019.
If Visual Studio 2019 is already installed, you can edit the list of workloads to include SSDT. If you don’t have Visual Studio 2019 installed, then you can download and install Visual Studio 2019 Community.
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 for the edition of Visual Studio that you want to add SSDT to, and then choose Modify.
-
Select SQL Server Data Tools under Data storage and processing in the list of workloads.
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.
| Project Templates | SQL Platforms Supported |
|---|---|
| Relational databases | SQL Server 2012 - SQL Server 2019 Azure SQL Database, Managed Instance Azure Synapse Analytics (dedicated pools only) |
| Analysis Services models Reporting Services reports |
SQL Server 2008 - SQL Server 2019 |
| Integration Services packages | SQL Server 2012 - SQL Server 2019 |
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).
After installing SSDT, work through these tutorials to learn how to create databases, packages, data models, and reports using SSDT.
[!INCLUDEget-help-options]