SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.


Leave a comment on the original post [www.jamesserra.com, opens in a new window]

Loading comments...