SQL Server Object Explorer in VS 2012

Posted Sun, Oct 21 2012 17:20 by Deborah Kurata

If you use Visual Studio AND SQL Server Management Studio, you'll be glad to hear that the SQL Server Management Studio tools, called SQL Server Data Tools (SSDT), are now a part of Visual Studio 2012. You can create, edit, and delete SQL Server tables and stored procedures, you can write and execute queries, you can view and edit database data, and so on, all from within Visual Studio.

NOTE: You can also get SSDT for Visual Studio 2010 SP1. See this link for more information.

SSDT includes database project types, the SQL Server Object Explorer toolbox, and tools to work with analysis services, reporting services and business intelligence.  This post focuses on just the SQL Server Object Explorer.

Select View | SQL Server Object Explorer from the Visual Studio menu to display the toolbox.

image

If your SQL Server does not appear on the list, click on the Add SQL Server button in the toolbar or  right-click on the SQL Server node and select Add SQL Server. Enter the information to connect to one of your SQL Server databases and your SQL Server should then appear on the list.

NOTE: You can connect to any running SQL instance, including SQL Azure.

Once your instance of SQL Server appears on the list, you can drill down to see the databases and their details. You can list the tables, views, and stored procedures under each database.

For example, here are the tables and stored procedures in one of my databases:

image

Follow these links to see some of the things you can do with the SQL Server Object Explorer:

Use the SQL Server Object Explorer to work with your SQL Server databases in Visual Studio 2012.

Enjoy!

Filed under: , , , , , ,

Comments

# Adding a New Database with SSDT

Sunday, October 21, 2012 10:58 PM by Deborah's Developer MindScape

No, SSDT is not a disease; it is a set of SQL Server Data Tools that are included as part of Visual Studio

# Adding Tables with SSDT

Monday, October 22, 2012 1:12 AM by Deborah's Developer MindScape

OK, no more SSDT jokes! SSDT, or SQL Server Data Tools, give you the features of SQL Server Management

# re: SQL Server Object Explorer in VS 2012

Friday, November 16, 2012 2:56 AM by Jeppe

Is it possible to restore a database from this the SSDT ? I cant find that option anywhere. would be great

# re: SQL Server Object Explorer in VS 2012

Wednesday, November 28, 2012 12:04 PM by Ivan

SQL can execute qrueies against a database, retrieve,update,insert data from a database and   empty refer to an empty result of no rows and NULL  refer to a table with one row holding a NULL value.

# SQL Server Data Tools (SSDT)

Monday, July 29, 2013 11:57 AM by Deborah's Developer MindScape

We all use some type of data in our applications: configuration information, game scores, map coordinates

# Adding Stored Procedures with SSDT

Monday, July 29, 2013 12:36 PM by Deborah's Developer MindScape

The SQL Server Object Explorer in Visual Studio 2012 is part of the SQL Server Data Tools (SSDT). You

# Entering Data with SSDT

Monday, July 29, 2013 12:53 PM by Deborah's Developer MindScape

When developing an application, it is often useful to have test data in the tables of your development

# Executing Stored Procedures with SSDT

Monday, July 29, 2013 1:06 PM by Deborah's Developer MindScape

As part of your development or debugging process, you may need to execute a stored procedure from your

# Executing a Stored Procedure With Parameters using SSDT

Monday, July 29, 2013 4:11 PM by Deborah's Developer MindScape

As detailed in this prior post , you can execute SQL Server stored procedures using the SQL Server Object

# re: SQL Server Object Explorer in VS 2012

Tuesday, July 30, 2013 10:25 AM by Deborah Kurata

Jeppe -

"Is it possible to restore a database from this the SSDT ? I cant find that option anywhere. would be great"

I have not seen an option to restore a database from the SQL Server Object Explorer. That is still one that you need to go to the Management Studio for. Same for a backup.

# SQL Server Database Projects

Tuesday, July 30, 2013 1:58 PM by Deborah's Developer MindScape

Visual Studio 2012 introduced yet another new database project. This new database project not only manages

# Scripting Reference Data with SQL Server Object Explorer

Monday, August 05, 2013 10:31 AM by Deborah's Developer MindScape

Database projects are great for scripting the tables and stored procedures for a database, but what about

# Creating a Merge Script for your Reference Data

Monday, August 05, 2013 2:04 PM by Deborah's Developer MindScape

When you create a database project data script using the SQL Server Object Explorer, it provides a set

# SSDT SQL Menu Options

Wednesday, August 07, 2013 9:09 AM by Deborah's Developer MindScape

The SQL Server Data Tools (SSDT) in Visual Studio include features in three areas of Visual Studio: SQL

# SSDT Data Editor Now Has Sorting and Filtering!

Thursday, April 17, 2014 2:22 PM by Deborah's Developer MindScape

The SQL Server Data Tools (SSDT) provide access to many SQL Server features from within Visual Studio

Leave a Comment

(required) 
(required) 
(optional)
(required) 
If you can't read this number refresh your screen
Enter the numbers above: