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 (SQL CLR) 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 J# Express
Visual Web Developer Express
Note