Note you can install these two products in any order: SSDT first, then SSDT-BI or visa-versa. It includes SQL Server Analysis Service Projects, SQL Server Reporting Services Projects, and SQL Server Integration Services Projects. 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). This will run the SQL Server 2014 install where you will select the feature “SQL Server Data Tools – Business Intelligence for Visual Studio 2012”. 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 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). This will run the SSDT install (not a SQL Server 2014 install). Last month I blogged that SQL Server Data Tools for SQL Server 2014 CTP2 now available.
