New Developer Tools for SQL Server, SharePoint, and Office

| by Jeff Martin Follow 16 Followers on Mar 12, 2013. Estimated reading time: 1 minute |

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:

Screenshot of BI template options

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.

Rate this Article

Adoption Stage

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread
Community comments

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread


Login to InfoQ to interact with what matters most to you.

Recover your password...


Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.


More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.


Stay up-to-date

Set up your notifications and don't miss out on content that matters to you