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 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 (CLR) Integration 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 |
|
Work with Query Designer |
Yes |
|
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 Web Developer Express