Export (0) Print
Expand All

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.

NoteNote

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

NoteNote

Features are available with all providers unless otherwise noted.

NoteNote

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

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

Community Additions

ADD
Show:
© 2014 Microsoft