Dela via


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 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

Concepts

What's New in Visual Database Tools

Other Resources

Overview of Visual Database Tools