SQL Server Data Tools - November 2012 is now available!

SQL Server Data Tools - November 2012 is now available!

Rate This
  • Comments 19


We are pleased to announce that SSDT - November 2012 update is now available for download. 

Get it here

SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015

SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014

What's new?

Selective XML Index support

We've added support for selective XML indexes, enabling users to import, edit, add, refactor, build, and publish selective XML indexes in SSDT.


Add new selective XML index in Table Designer

Check for SSDT Updates

This release adds support for automatic and manual checks for SSDT updates.  You can view information about your current SSDT installation and verify that it's up to date by selecting "Check for Updates…" under the top-level SQL menu in Visual Studio.


 Check for Updates dialog

This feature also notifies users when a newer version of SSDT is available for download.


SSDT update notification

Updated Data-Tier Application Framework (DACFx)

SSDT – November 2012 includes the October DACFx redist (11.1.2816.0). The October DACFx release contains several feature enhancements and bug fixes outlined in this post: http://blogs.msdn.com/b/ssdt/archive/2012/10/10/sql-server-data-tier-application-framework-october-2012-available.aspx

Updated SQL Server 2012 components

SSDT – November 2012 is coordinated with the release of SQL Server 2012 Service Pack 1 and it chains in the latest SQL Server components.

Bug fixes

This release contains over 30 bug fixes, including fixes for customer-reported issues from SSDT - September 2012.

Power Tools Compatibility

The November 2012 update of SSDT is only compatible with the latest SSDT Power Tools (v 1.4).  Please note that if you have an existing version of SSDT Power Tools, it will need to be upgraded in order to work with SSDT – November 2012.  Edit: SSDT Power Tools are no longer available via the links below, but have been integrated into the core SSDT product in the December 2012 release (http://blogs.msdn.com/b/ssdt/archive/2012/12/13/available-today-ssdt-december-2012.aspx

SSDT Power Tools for Visual Studio 2012

SSDT Power Tools for Visual Studio 2010

Contact Us

If you have any questions or feedback, please visit our forum or Microsoft Connect page.  We look forward to hearing from you.

Leave a Comment
  • Please add 3 and 6 and type the answer here:
  • Post
  • @Howard SSDT does not provide any data cleansing features

  • I have installed Visual Studio Profession 2012 with SP1 from my MSDN benefits subscription, and have installed the latest November version of SSDT which is suppose to integrate with VS 2012, however it's not working. I have also installed SQL Server 2012 STandard edition selecting all reporting services tools.

    This is the november SSDT install link i used: msdn.microsoft.com/.../jj650015

    When i open VS 2012 professional and try to create a new project I can't see any business intelligence templates, such as the project template for reporting services project.  When I open VS 2010 it does however show.

    What did i miss?  THanks

  • Greg, from the SSDT FAQ:

    In the SQL Server 2012 installer, developers can install the BIDS tools for Visual Studio 2010 by selecting SSDT during installation... In the web acquision experience, however, the SSDT shell only includes the database projects component. Installing SSDT from the web will not install BIDS tools.

    Also, SSIS/AS/RS are not yet available in VS 2012

  • Can the script task in SSIS 2012 now access the entity framework?

Page 2 of 2 (19 items) 12