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 (SSDT) – September 2012 update

SQL Server Data Tools (SSDT) has a new update (version 11.1.20905, with the previous version being 11.1.20225).  The SSDT team is committed to delivering regular, frequent releases of SSDT, and this is the first in a long line of updates.  This release of SSDT now supports the Visual Studio 2012 shell, so SSDT is now available for both Visual Studio 2012 and Visual Studio 2010 (actually you could optionally install SSDT when installing Visual Studio 2012, so this new support of the Visual Studio 2012 shell is for the stand-alone version of SSDT).

This update contains several bug fixes to the SSDT version (11.1.20627) that shipped in Visual Studio 2012 (you have the option of installing SSDT when installing Visual Studio 2012) and this release can be applied as an update on top of Visual Studio 2012 Professional, Premium, and Ultimate Editions.  If one of these SKUs is not present on the box, running the SSDT installer for Visual Studio 2012 will lay down a standalone version of SSDT for the Visual Studio 2012 Integrated Shell (which will appear on the start menu as “Microsoft SQL Server Data Tools 2012″).

Keep in mind that the underlying engine and functionality for SSDT – September 2012 is the same for both Visual Studio 2010 and Visual Studio 2012, so you don’t need to upgrade to Visual Studio 2012 to use the latest version of SSDT.

Unfortunately this update does not include updates to the Business Intelligence templates (SSAS/SSIS/SSRS), so those still only work with Visual Studio 2010.

Download it here.


  • Improved LocalDB configuration
  • Support for ANSI_NULLS and QUOTED_IDENIFIER properties on project and script files
  • Support for Visual Studio 2012 Integrated Shell
  • Updated Data-Tier Application Framework
  • Bug fixes to customer-reported issues

Also updated is SSDT Power Tools.  Download it here.  It also now supports both Visual Studio 2012 and Visual Studio 2010 shells.  Power Tools as a mechanism to deliver new functionality and experiences through frequent updates.  It’s a way to get early versions of experiences or quick features to everyone, and Microsoft is always interested in hearing your feedback.  These updated Power Tools rely on the September 2012 update, so make sure that you install that first.


  • Extract, Publish, and Register actions for .dacpacs
  • .dacpacs with data
  • “Script As…” functionality
  • Grouping and filtering objects

More info:

Now available: SQL Server Data Tools – September 2012 update!

New SSDT Power Tools! Now for both Visual Studio 2010 and Visual Studio 2012

FAQ: Microsoft SQL Server Data Tools


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

Loading comments...