Download SQL Server Management Studio 2016 Preview and Get ready

SQL Server Management Studio(SSMS) is an integrated environment consisting of several components made expressely for managing SQL Server infrastructure and Azure SQL Database (Azure Cloud). Using SSMS you can:

• Configure
• Monitor
• Administer instances of SQL Server.

It has full set of  Data-Tier Technology tools for databases and data warehouses

• Deploy
• Monitor
• Upgrade

It can do a lot more than the above that includes,
Download your free copy from here:
https://msdn.microsoft.com/library/mt238290.aspx
http://download.microsoft.com/download/8/6/3/8639523C-7F12-4CC3-8D2F-908C7A78B4C6/SSMS-Setup-ENU.exe

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.

Deploying DAC to SQL Server 2014

The acronym DAC in SQL Server has many different meanings as in the following bullet list:

• DAC - Data-tier Application
• DAC - Dedicated Administrator Connection
• DAC - Data Access Components
• DAC - Data Application Component

This post describes deploying a Data-tier Application extracted from SQL Server 2012 Express database to SQL Server 2014 CTP1 (should work with CTP2 as well). The two servers are on two partitions on a x64 bit Windows laptop, with SQL Server 2012 on Windows 7 Partition and CTP1 on Windows 8 Preview partition.

There are no issues for this deployment and the next few images shows the stages of deployment wizard while deploying to SQL Server 2014 CTP1. We start with a .dac file created on Windows 7 partition and copied over to the desktop on Windows 8 partition.

 

The steps are very clear and you may also review the following for more detailed discussion of DAC with earlier versions on older OS.


https://www.packtpub.com/article/working-with-data-application-components-sql-server-2008-r2
http://hodentekmsss.blogspot.com/2010/07/sql-server-2008-r2-and-data-tier.html