BT

New Developer Tools for SQL Server, SharePoint, and Office

by Jeff Martin on Mar 12, 2013 |

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.

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

Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT