SQL Server Data Tools for Visual Studio 2013

There are several options for SQL Server Data Tools depending on the version of Visual Studio as described here.

For this post we are using a Toshiba Laptop running Windows 7 (64-bit) Ultimate having a Visual Studio Express 2013 for Web which is one of the requirements in the following list:

• Visual Studio 2013 Professional,
• Ultimate,
• Premium,
• Express for Web, or
• Express for Windows Desktop

You can download the tool here:
https://msdn.microsoft.com/en-us/dn864412

You will need approximately 1.8GB of free space at for the full install point because it includes all possible components that might be required.

You have an option for the language to choose from:

SSDT_01
Choose language and download (English here).

You double click the downloaded program SSDTSetup.exe to begin installation.

SSDT_02

Accept the license terms to proceed.
The download and installation begins immediately.

SSDT_03
It may take a while to download and install.

SSDT_04

After installation you can find Visual Studio 2013 Data Tools as shown.

SSDT_05

A number of items will be added to your Control Panel Programs as shown.

SSDT_06
You can verify it in Visual Studio 2013 Express for web also as shown.

SSDT_07

How do you create SQL Server Projects using the SSDT?
Hints for creating projects:
Launch VS 2013 Web (for example)
Create New Project choosing SQL Server Project Template
Associate a SQL Server Database for the project by directly connecting to SQL Server; choosing to run a script or via a data-tier application

In the next post we look at using SQL Server Data Tools in Visual Studio 2013 Express for Web.

Hands-on Learning Event in Honolulu 2: SQL Server Reporting Services 2012

The class is forming and is expected to start in August 2015. Please register at the PCATT.ORG site.

SQL Server 2012 Express or Developer Edition will be used.

For details you can also write to:
Hodentek@live.com with course name in the Subject line.

Here are Reporting Services books published by the instructor:

 

 

You can buy these and many other computer and programming related books here:

https://www.packtpub.com/books/info/authors/jayaram-krishnaswamy

 

 

What is a SQL Server Managment Studio project and how to create one?

SQL Server Management Studio provides a means to group together all your codes in one place as part of a SQL Server Project. A solution is a container for a project(s) containing all logically related scripts and files in one place. It is available even in SQL Server 2012 Express. This is the platform to use if you want to develop scripts for Database Engine and Analysis Services.

A solution explorer is a pane in SQL Server Management Studio with project containers for managing scripts and files. The concept of Solutions and Projects in Visual Studio is too well known requiring elaboration and this is carried over to SSMS and in fact SQL Server is tightly coupled with Visual Studio. In Visual Studio you can carry a lotsof things that you do in SSMS

How to display Solution Explorer in SQL Server Management Studio?

• Click File | New | Project... in SSMS to open the New Project window of Visual Studio as shown.

 

•  If you choose SQL Server Management Studio Solution then the above interface adds a Blank Solution to which you may add projects. On the other hand
  If you choose SQL Server Management Studio projects then you have the option of adding a SQL Server scripts project or a Analysis Services scripts project as shown.

• When you accept the option of creating a SQL Serverscripts project Visual Studio creates a Solution and a project within the solution as shown. The Project has folders for Connections, Queries and Miscellaneous scripts.  The default location of the project is at (generally at the logged in Users folder): 

c:\users\mysorian\documents\sql server management studio\Dec2013\Dec2013\Dec2013.ssmssqlproj 

 

The properties of the solutions shows where the source code is located.

• From the Solution node you can create a new project or add an existing project to it.
  
  From the project node (right click) you can add New Item, or an existing item, or a new query, or a new connection.

When you click add New Item, the VS interface is displayed as shown,

• You can start off with any of the templates to create a query. 

You can open the same project using File | Open |Project/Solution... in SSMS as shown here.

 

This displays the  Solution explorer as shown by accessing the Source saved on SSMS as shown.

Now you will be developing the project in SQL Server Management Studio.

You can do it both ways or in mixed mode.