SQL Server Data Tools for SQL Server 2014 is available

SQL Server Data Tools for SQL Server 2014 is available

Rate This
  • Comments 30

We’d like to announce the availability of the latest March 2014 release of SSDT with support for SQL Server 2014 databases. This version is fully compatible with SQL Server 2014.

This update is now available for Visual Studio 2012 and 2013. For Visual Studio 2012 use the “SQL –> Check for Updates” tool inside Visual Studio or download via the download link below. For Visual Studio 2013 download check the Visual Studio update channel (Tools –> Extensions and Updates –> Updates) for this update.

Please note that this release is for the SQL Server database tooling in Visual Studio, not for SSDT-BI. SSDT-BI is a distinct toolset from SSDT or the SQL Server database tooling in Visual Studio and an update for this product will be released at a later date.

Get it here: http://msdn.microsoft.com/en-us/data/hh297027

Contact Us

If you have any questions or feedback, please visit our forum or Microsoft Connect page
We look forward to hearing from you.

 

What’s New

The most important new feature is support for SQL Server 2014. We also have a number of new features for users of any SQL Server release, including Windows Azure SQL Database, plus plenty of bug fixes for issues raised by customers.

Filtering Data

When choosing to “View Data” on a table in SQL Server Object Explorer it can sometimes be hard to locate specific information. The Filter and Sort Dialog Box lets you:

· Hide columns you don't want to see.

· Filter on column values.

· Add an alias for a column.

· Sort on one or more columns.

image

Custom Static Code Analysis rules

You can now write custom rules to detect problems not covered by the built-in validation and static code analysis rules provided in database tooling. We will be adding an updated walkthrough to our help documentation and have updated our samples project. The samples project includes the code from the walkthrough plus some additional sample rules that may prove useful.

Azure Integration

Support for discovering and navigating to Windows Azure SQL Database nodes was included in Visual Studio 2013 at release. For those of you not familiar with this, the current implementation takes the pain out of discovering and adding Azure databases into the SQL Server Object Explorer:

clip_image003

With this feature you no longer need to figure out the server name for your database or configure a firewall rule for your machine in the Azure Management Portal. This simplifies keeping your Windows Azure SQL Databases in sync with your development environment.

In this release you can navigate straight from Visual Studio to your database in the Management Portal:

clip_image004

Transact-SQL Editor

The Connection menu option now has suboptions for Disconnect All Queries and Change Connection. This makes the editor more consistent with the experience in SQL Server Management Studio.

Change Connection lets you change the Transact-SQL connection to a different server in a single step. Previously you had disconnect and then connect to the new server.

Disconnect All Queries allows you to disconnect all open Transact-SQL query windows.

clip_image005

Data Compare

Saving Data Compare settings is now supported. Clicking save will create a .dcmp file with the required connection information and name.

Changes to Database Tools Extensibility

New Extension Installation Directory

With the new release of SQL Server Data Tools the core DacFx components are now installed directly inside Visual Studio. This has the benefit of supporting multiple Visual Studio versions (e.g. VS 2010, 2012 and 2013) side by side on the same machine without requiring every version to be compatible with the same DacFx binaries.

This does have an effect on any extensions such as Build/Deployment contributors you may have written. These should now be installed in the <Visual Studio Install Dir>\Common7\IDE\Extensions\Microsoft\SQLDB\DAC\120\Extensions directory. You may also need to recompile your extensions against the latest version of DacFx as the major version has been incremented, and this may break binary compatibility.

There will be a new help topic “How to: Install and Manage Feature Extensions” covering installation of all supported extension types that covers this topic.

Leave a Comment
  • Please add 1 and 7 and type the answer here:
  • Post
  • Hi Kevin,

    Great set of new features. I knew Change Connection was coming but fantastic that we now have custom code analysis rules. I need to go and update my slide decks :)

  • I hope it will be released soon on MSDN!

  • much appreciated, thanks for the detailed feature overview. Is there a bug fix list available ?

  • How about SSDT BI, is there a march release as well ?

  • 1.  The plan is to release SSDT-BI when SQL Server 2014 GA's.  (soon).

    2.  There's a ton of bug fixes in this release since we haven't released an SSDT (the SQL Server 2014 CTP1 version doesn't count) since late 2013.  Rather than go through the list we're responding via Connect that those issues have been fixed.  If you have anything in mind I can research.

  • Any chance that we can now specify things like ONLINE=ON or MAXDOP when creating indexes and have those passed through to the SQL Server when we publish our changes? Missing the ability to do that makes pushing our changes quite a bit harder using just SQLPackage.

  • Any update?  SQL Server 2014 just RTW'd on MSDN.  Will we get both an SSDT and SSDT-BI update?

  • @colin- both SSDT and SSDT-BI updates for Visual Studio 2013 will be released in the next few days. During the rollout of the SSDT for Visual Studio 2012 we discovered some issues and are taking a few extra days to resolve these before releasing. SSDT-BI announcements will be on their blogs so I would monitor those for updates on that release.

    @Peter- I recommend asking a question on the forum (social.msdn.microsoft.com/.../home) as it's much easier to understand your requirements and have a discussion there. If you can post an example that's not supported we can investigate, see if there are workarounds etc.

  • SSDT-BI for VS2013 has been released. Full release information and a download linke are available on the Analysis Services blog: blogs.msdn.com/.../sql-server-data-tools-business-intelligence-for-visual-studio-2013-ssdt-bi.aspx

  • SSDT for Visual Studio 2013 has just been released. Check the Visual Studio update channel (Tools –> Extensions and Updates –> Updates) for this update.

  • Do we have a list of what is installed for this update, as it seems to install SQL 2014 Express and SQL 2014 Management Studio.  

    I only ask as I wanted to also install SQL Server Management Studio which is available as a full install on the SQL 2014 Express download page.

    msdn.microsoft.com/.../dn434042.aspx

    Would I still need to download the Full SQL 2014 Express or just the Studio?

  • @Denis - SSDT installs SQL Server Express LocalDB. This is one of the express variants but is different from "SQL Express". In addition it installs a number of common shared components but not SSMS. Looking at the link you included it seems like there are 2 options: SSMS on its own or SSMS + SQL Express. It's up to you which you want to install, but that does seem to be the correct download page.

  • We are in the process of switching from dbproj to sqlproj projects (VS 2010 -> VS 2013).  Is there a way that we can get SSDT installed on our build server (TFS 2010 currently, moving to TFS 2013 shortly) without having to install some VS SKU there?

  • With ton of bug fixes there is ton of new ones. January 2014 version disabled me from processing cube on deployment server. While this is fixed in March 2014 version I cannot view SSRS reports anymore... It's just becomes boring.

  • Adrian,

          Please see this link about setting up SSDT without running the full SSDT IDE install.

    sqlproj.com/.../headless-msbuild-support-for-ssdt-sqlproj-projects

    Since SSDTVS2013 is not available as a separate install outside of the VS2013 ide, you could simply pick

    the SSDT VS2012 installer from this link download.microsoft.com/.../SSDT_11.1.40403.0_EN.iso and install just the 5 MSI packages for the platform (x86 or x64) you have in mind:

    Install the Microsoft® SQL Server® 2012 Data-Tier Application FrameworkX86 Package(dacframework.msi)X64 Package (dacframework.msi)

    Install the Microsoft® SQL Server® 2012 Transact-SQL ScriptDomX86 Package(SQLDOM.MSI)X64 Package (SQLDOM.MSI)

    Install the Microsoft® SQL Server® 2012 Transact-SQL Compiler ServiceX86 Package(SQLLS.MSI)X64 Package (SQLLS.MSI)

    Install the Microsoft® System CLR Types for Microsoft® SQL Server® 2012X86 Package(SQLSysClrTypes.msi)X64 Package (SQLSysClrTypes.msi)

    Install the SQL Server Data Tools Build Utilities from the Administrative install point.\ssdt\x86\SSDTBuildUtilities.msi

Page 1 of 2 (30 items) 12