Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

SQL Server Data Tools BI (SSDT-BI) for SQL Server 2014

Last month I blogged that SQL Server Data Tools for SQL Server 2014 CTP2 now available.  You can download that here.  This will run the SSDT install (not a SQL Server 2014 install).  This installs the Visual Studio 2012 shell, and makes available the SQL Server Database Project as well as the “SQL” menu in Visual Studio (which contains Schema Compare, Data Compare, and Transact-SQL Editor).  It installs version 11.1.31024.0 of SSDT.

Just released is a Community Technology Preview (CTP) of the SQL Server Data Tools – Business Intelligence (SSDT-BI) tools that work with SQL Server 2014 CTP2.  This CTP release can be downloaded here.  This will run the SQL Server 2014 install where you will select the feature “SQL Server Data Tools – Business Intelligence for Visual Studio 2012″.  When running the install, choose “Perform a new installation of SQL Server 2014 CTP2″ (which is strange because you are adding a new feature and not performing a new install, but that is the option you need to choose).  It includes SQL Server Analysis Service Projects, SQL Server Reporting Services Projects, and SQL Server Integration Services Projects.

Note you can install these two products in any order: SSDT first, then SSDT-BI or visa-versa.  If you don’t have Visual Studio 2012 on your machine, either product will install the Visual Studio 2012 integrated shell with those new projects.

Also note that the commercial release of SSDT-BI is expected to be based on the newer Visual Studio 2013 in conjunction with the commercial release of SQL Server 2014.

SSDT-BI for SQL Server 2014 will support various SQL Server versions as follows:

  • SSAS projects can target SQL Server 2014 or lower
  • SSRS projects can target SQL Server 2014 or lower
  • SSIS projects can target only SQL Server 2014

What was previously available as an add-in for Visual Studio 2010 and updated for Visual Studio 2012, the SQL Server Database Project, is now an integrated feature of both Visual Studio 2012 and 2013 (called SQL Server Database Tooling in Visual Studio 2013).  Along with being integrated in the full Visual Studio SKUs, database developers without Visual Studio can install them for free as standalone tools also.

Please note the current versions of SSDT and SSDT-BI work with, and will continue to work with, SQL Server 2014 (one exception: it won’t work with the new SQL Server 2014 SSIS projects at general availability).  So what you are really only getting with the CTP versions of SSDT is an alignment with the new version of Visual Studio 2013.  Whenever there is a new version of Visual Studio, you can expect at the same time a new version of SSDT and SSDT-BI that uses the new version of Visual Studio.

More info:

Microsoft SQL Server Data Tools Update


Leave a comment on the original post [, opens in a new window]

Loading comments...