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 |
|
| Work with Query Designer | Yes | Yes | Results pane only |
|
| 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
Note