Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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.

Visual Database Tools Features

Feature Visual Studio Professional Visual Studio Standard Visual Web Developer 2005 Express Edition ( available with local and read-only remote connections) *Visual Studio Express Editions (only available with local connections unless otherwise noted)

Create/Modify/Remove/Refresh connection

Yes

Yes

Yes

Yes

Add a SQL Database from Server Explorer

Microsoft SQL Server

Microsoft SQL Server

Yes

Yes

Change Database Views in Server Explorer

Microsoft SQL Server

Microsoft SQL Server

No

No

Work with Database Projects

Yes

No

No

No

Open or Debug SQL CLR Database Objects

Yes

No

No

No

Run Database Objects

Yes

Yes

Yes

Local and remote connections

Work with Table Designer

Microsoft SQL Server

Microsoft SQL Server

No

No

Work with Database Diagram Designer

Microsoft SQL Server

Microsoft SQL Server

No

No

Work with View Designer

Microsoft SQL Server

Microsoft SQL Server

Results pane only

  • Results pane only

  • Local and remote connections

Work with Query Designer

Yes

Yes

Results pane only

  • Results pane only

  • Local and remote connections

Work with Query Builder

No

No

Open from Server Explorer only

Open from Server Explorer with local and remote connections and from the SQL Editor.

Work with T-SQL Editor

Yes

Yes

Yes

Yes

Create/modify Stored Procedures

Microsoft SQL Server

Microsoft SQL Server

Yes

Yes

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

Microsoft SQL Server

Microsoft SQL Server

Yes

Yes

Create/modify Triggers

Microsoft SQL Server

Microsoft SQL Server

Yes

Yes

Create/modify Scripts

Microsoft SQL Server

Microsoft SQL Server

No

No

*The versions of Visual Studio Express Editions are:

  • Visual Basic Express Edition

  • Visual C# 2005 Express Edition

  • Visual C++ 2005 Express Edition

  • Visual J# 2005 Express Edition

See Also

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

Show:
© 2014 Microsoft