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