SQL projects tools

SQL projects tools

Tooling for SQL projects is available in several development environments and command line

interfaces. The primary tools for SQL projects are the

SqlPackage

command line utility,

(SSDT) in Visual Studio, and the

SQL Database Projects extension

for Visual

Studio Code.

Tools included in this article:

Graphical tools

SQL Database Projects extension

Database DevOps in SQL Server Management Studio

Data Tools

Command line tools

SqlPackage

These tools provide a graphical interface for SQL projects, a Transact-SQL (T-SQL) editor, and a

build and publish process.

SQL Database Projects extension

is an extension for. This extension

provides a graphical interface for SQL projects, a T-SQL editor, and a build and publish process.

Database DevOps

in

Management Studio (SSMS)

provides a graphical interface for

SQL projects, a T-SQL editor, and a build and publish process.

Data Tools

(SSDT) is a

component that provides a graphical interface

for SQL projects. SSDT provides a visual designer for tables, a T-SQL editor, and a build and

publish process.

Create new empty project

Yes

Yes

Yes

Yes

ﾉ

Expand table