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
See Also
Concepts
What's New in Visual Database Tools