Installing and using SQL Server Data Tools (SSDT) on Visual Studio 2010 and VWD

This blog post shows how to Install SQL Server Data Tools on Visual Studio 2010 and Visual Web Developer/2010. This MSDN article, also shows how to install Install SQL Server Data Tools.

Launch WPI 4.0 ( Web Platform Installer )

StartWPI

Select All in the left pane and Products from the top. In the search box enter SSDT .

WPI_Search1

Add  and install SSDT.

addSSDT

If you are using VWD, the SSDT installation will install the shell for the professional version of Visual Studio 2010. You will need to use this shell to access SSDT. If you are using Visual Studio 2010 Professional Edition (or higher), the tools will be integrated into Visual Studio. For VWD folks, launch SSDT:

 Launch SSDT

From the SQL  menu, select Add SQL Server.

SSDT_SQL_addSqlServer

In the Connect to Server dialog, enter the Server name string "(LocalDB)\v11.0".

SSDT_connectToSeverDlg

From the View menu, select SQL Sever Object Explorer.

SQL_Obj_Explorer

Double click the (LocalDB) entry, then select the DB and the table you wish to examine.

SS_ObjectExp_LocalDB

 

SS_ObjectExp_LocalDB_Table

designViewMovies

In addition to blogging, I use Twitter to make quick posts and share links. My Twitter handle is: @RickAndMSFT