New Developer Tools for SQL Server, SharePoint, and Office
Developers looking to develop business intelligence projects for SQL Server 2012 can now do so with the newly released Microsoft SQL Server Data Tools - Business Intelligence (SSDT-BI) software. These tools can be used to target SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012 and SQL Azure.
Installing the SSDT BI package will provide the ability to create projects based on the following templates: analysis, reporting, and integration services. Once installed, new templates appear under the category of Business Intelligence:
What do these SQL Server Data Tools enable users to do? Microsoft describes them as follows:
"Developers will also appreciate the familiar VS tools we bring to database development, specifically; code navigation, IntelliSense, language support that parallels what is available for C# and VB, platform-specific validation, debugging and declarative editing in the TSQL Editor, as well as a visual Table Designer for both database projects and online database instances."
This latest edition of the tools does support project support round-tripping, so users can upgrade to 2012 and still interoperate with 2010-based files. Users of the Express editions of VS2012 can also install BI alongside their current installation. Another expected feature is that this release brings the toolset into alignment with the VS2012 GUI shell.
Office Developer Tools
Not to be outdone, the Office team has also released developer tools (note link is to installer) for VS2012. These tools enable developers to create apps for Office and SharePoint. Among the new features, this latest release supports .NET Framework 4.5 to enable building apps for Office 2013 and the ability to remotely debug a SharePoint site. Developers who previously manually created bootstrapper packages to provide .NET 4.5 functionality no longer need do so with this release. Note that unlike the BI tools above, the Office Developer Tools require VS2012 Professional or higher.
Olav Maassen, Liz Keogh & Chris Matts Mar 08, 2014