แก้ไข

แชร์ผ่าน


SQL Server Data Tools

SQL Server 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.

Screenshot of graphic with SQL Server Data Tools component and three extensions.

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 in Download SQL Server Data Tools.

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 Azure Data Studio and VS Code. For more information, see SQL Server Data Tools, SDK-style (preview).

Release notes

The latest release notes for SQL Server Data Tools with Visual Studio 2022 can be found in the following locations:

The release notes for SQL Server Data Tools with Visual Studio 2019 can be found in the following locations:

For information about SQL Server Data Tools with Visual Studio 2017, see Previous releases of SQL Server Data Tools (SSDT and SSDT-BI).

Core SQL Server Data Tools

SQL Server Data Tools (SSDT) transforms database development by introducing a ubiquitous, declarative model (SQL database projects) that spans all the phases of database development inside Visual Studio. SSDT Transact-SQL design capabilities can be used to build, debug, maintain, and refactor databases. You can work with a database project or directly connect to a database instance on or off-premises.

Developers can use the familiar Visual Studio environment for comprehensive database development. The suite of tools includes code navigation, IntelliSense, and language support akin to what is available for C# and Visual Basic, along with specialized validation, debugging, and declarative editing within the Transact-SQL editor. SQL Server Data Tools (SSDT) also offers a visual table designer for streamlined creation and modification of tables in database projects or connected instances. In team-based settings, version control is available for all project files, enhancing collaboration. When it's time to deploy, projects can be published across all supported SQL platforms, such as SQL Database and SQL Server.

The SQL Server Object Explorer in Visual Studio offers a view of your database objects like SQL Server Management Studio. SQL Server Object Explorer lets you do light-duty database administration and design work. You can easily create, edit, rename, and delete tables, stored procedures, types, and functions. You can also edit table data, compare schemas, or execute queries using contextual menus from the SQL Server Object Explorer.

Learn more about SQL projects and database development tasks that you can accomplish with SQL Server Data Tools in the SQL database projects documentation.

SDK-style SQL projects (preview)

Support for the Microsoft.Build.Sql project SDK is available in preview in Visual Studio as the next generation of SQL projects. The SDK-style SQL projects are based on the .NET SDK-style project format and are designed to be more flexible and extensible than the original SQL projects. The SDK-style SQL projects are recommended for new development and are available in Visual Studio 2022 as an optional component "SQL Server Data Tools, SDK-style (preview)." Learn more about the SDK-style SQL projects and Visual Studio in the SDK-style SQL Server Data Tools documentation.