SQL Server Data Tools Overview

Data Tools

Data Tools (SSDT)

is a set of development tools in Visual Studio with focus on

building SQL Server databases and Azure SQL databases. SSDT can be extended to Analysis

Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS)

reports with their corresponding extensions. SSDT allows you to 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 core of SQL Server Data Tools functionality is available as a workload component with

Visual Studio. The Visual Studio extensions are available from the Visual Studio Marketplace

and more information on installing SSDT can be found at

Install SQL Server Data Tools (SSDT)

for Visual Studio.

７

Note

SDK-style SQL projects in Visual Studio are available as part of the

Data Tools,

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

Data Tools, SDK-style (preview).