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 )


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


Add  and install SSDT.


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.


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


From the View menu, select SQL Sever Object Explorer.


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





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