Udostępnij za pośrednictwem


Visual Database Tools Editions

Visual Database Tools are included in multiple editions of Visual Studio. The following table describes the different features available with each edition.

Note

Features are available for connections to databases on the client (local) and remote computers unless otherwise noted.

Note

Features are available with all providers unless otherwise noted.

Note

Express editions use the term Database Explorer, while the other editions use Server Explorer.

Visual Database Tools Features

Feature

Visual Studio Professional, Visual Studio Premium, or Visual Studio Ultimate.

*Visual Studio Express Editions (only available with local connections unless otherwise noted)

Create/Modify/Remove/Refresh connection

Yes

Yes

Add a SQL Server database from Server Explorer

Microsoft SQL Server

Yes

Change Database Views in Server Explorer

Microsoft SQL Server

No

Work with Database Projects

Yes

No

Open or Debug SQL Server Common Language Run-time (SQL CLR) Database Objects

Yes

No

Run Database Objects

Yes

Local and remote connections

Work with Table Designer

Microsoft SQL Server

No

Work with Database Diagram Designer

Microsoft SQL Server

No

Work with View Designer

Microsoft SQL Server

  • Results pane only

  • Local and remote connections

Work with Query Designer

Yes

  • Results pane only

  • Local and remote connections

Work with Query Builder

No

Open from Server Explorer with local and remote connections and from the Transact-SQL editor.

Work with Transact-SQL Editor

Yes

Yes

Create/modify Stored Procedures

Microsoft SQL Server

Yes

Create/modify User-defined Functions (Scalar, Inline, Table-valued)

Microsoft SQL Server

Yes

Create/modify Triggers

Microsoft SQL Server

Yes

Create/modify Scripts

Microsoft SQL Server

No

Remote SQL Server connections

Yes

Only in Visual Web Developer Express

*The versions of Visual Studio Express are:

  • Visual Basic Express

  • Visual C# Express 

  • Visual C++ Express

  • Visual J# Express

  • Visual Web Developer Express

See Also

Concepts

What's New in Visual Database Tools

Other Resources

Overview of Visual Database Tools