Available Today: SSDT—December 2012

Available Today: SSDT—December 2012

Rate This
  • Comments 43

The SSDT team is pleased to announce that SQL Server Data Tools - December 2012 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?

Database Unit Testing

We have received an overwhelming amount of feedback that database unit testing is a critical feature for customers, so SSDT- December 2012 adds support for this feature. Database Unit Testing in SSDT will look familiar to many of you as it is based on the equivalent capability in the Visual Studio 2010 DB Pro tools.  Some highlights:

  • Installs in Visual Studio 2010 or Visual Studio 2012:
    • Requires Visual Studio Professional or higher edition to support database unit testing functionality.
    • Installs side-by-side with existing Visual Studio 2010 DB Pro tools in Visual Studio Premium and Ultimate editions.
  • Supports client-side testing based on MSTest with the same built-in test conditions as DB Pro.
  • Allows desktop development and execution of tests as well as execution from the command line or as part of a build on a build server.
  • Upgrades existing VS 2010 test projects without change to the database unit test scripts or code.
  • Integrates with SSDT SQL Server database projects:
    • Automates deployment of the database project on test initialization.
    • Generates skeleton test scripts for stored procedures, functions and triggers via SQL Server Object Explorer.
    • Applies changes to test scripts when refactoring objects in database projects.    
  • Supports custom test conditions (existing custom test conditions need to be modified before they can be used).

Stay tuned for a follow-up post on getting started with SQL Server database unit testing. 

Integration of SSDT Power Tools

The SSDT team started releasing SSDT Power Tools last April as a mechanism to deliver new and experimental features with each release. Since then, the Power Tools have been downloaded over 24,500 times.

We received a great deal of positive feedback on the Power Tools and as a response, this release integrates the functionality previously delivered via Power Tools into the core SSDT product. The advantage of product inclusion is that a separate install will no longer be needed and that features are now fully supported and available to users in all languages. The following features are now included in SSDT's SQL Server Object Explorer:

Projects node adds the equivalent of Schema View to SSDT. You can use this node to browse the logical schema of your project and to edit, refactor, and add new objects. 

Script As support in SSOX enables you to generate Create, Alter, Drop, and Drop and Create-To scripts for objects in your connected database.

DAC actions allow you to perform similar DAC-based tasks in SSDT to those available in SSMS.  You can extract a dacpac from a live database, publish a dacpac to a database, register a database as a DAC, or remove the registration metadata for a database registered as a DAC. These actions are supported for both on-premises SQL Server databases as well as Windows Azure SQL Databases.


We recommend that you uninstall the SSDT Power Tools extension if you had it previously installed.

Updated Data-Tier Application Framework

This release includes the November 2012 release of SQL Server Data-Tier Application Framework (DACFx), which contains several feature enhancements and bug fixes.  You can learn more about the latest release of DACFx here.

Bug fixes

SSDT - December 2012 contains over 50 bug fixes, including fixes for customer-reported issues from SSDT - November 2012 and SSDT Power Tools releases.

Contact Us

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

Leave a Comment
  • Please add 7 and 3 and type the answer here:
  • Post
  • I'm trying to install SSDT and it seems to hang. Any ideas? The dowload progress bar is completely green and the installation progress bar is completely green, but all I have is a cancel button and no other dialog to finish....

  • Ok, seems I had to do a reboot and then the install worked successfully.

  • I'm not seeing an update on the update tool in Visual Studio. It claims the installation is up-to-date, with version numbers 11.1.21101.1 for both SSDT and SSDT Build Utilities, and 11.1.2820.0 for DacFX. Any ideas?

  • I think Joe's observation is correct. In my case the screen hung on the following:

    86b4d378-8e43..  etc. It stayed on for about 2 hours. I cancelled and re-run the executable. It installed correctly at the second attempt.


  • Will you be giving us back the ability to save the compare options like we had in VS 2010 ?  Seems like that's a fundamental thing needed in version 1.  I really miss that.

  • After installing the new version I got errors while loading an existing database project:

    "this template attempted to load component assembly 'Microsoft.VisualStudio.Data.Tools.Package, Version=, Culture...........'

    What can this be?

    (Also the forum link on this page top-right does not work)

  • Dean, Schema Compare in SSDT allows you to save a comparison as an .scmp file, which includes your comparison options.  To use this, create a Schema Compare, select File > Save <comparison>.scmp, or Save <comparison>.scmp As.  

    If you create a Schema Compare file from the SQL menu (so it has no selected source or target), set the options you want and then save the file, you can create a template for future comparisons that you can customize and optionally save to a new file.  

    Is there more than this that you are looking for?

  • When can we expect to see full integration of SSDT for Visual Studio 2012 and the BI products/project templates IE SSIS, SSAS, SSRS (all 2012 versions of course)

  • Seems the comments on here are either being dropped or censored.

  • SSDT installed fine on Visual Studio 2012, but whenever I try to go to the unit test designer it crashes. Any ideas?

  • Did the 50 bug fixes include the implementation of SQL standard authentication with the web deploy provider (dbDacFx)?

    See the MSFT acknowledgement of the bug @  stackoverflow.com/.../web-deploy-impersonation-management-service-delegation-does-not-work

  • I hope merging the new DB Unit Tests are much easier than before! TFS merging was painful with these UnitTests in previous version.

  • In the web acquisition experience of SSDT, only the database project component is included (SSIS/AS/RS are not).  Currently, these tools are not yet available for the Visual Studio 2012 shell.

    SSDT doesn't ship any web deploy components so this release wouldn't be an avenue for the web deploy bug fix mentioned above.

    For help with setup issues or to report a bug, please use the forum or Microsoft Connect page

  • Does this include the BI Tools (SSIS & SSRS) too please? We've been waiting a while for this.

  • @preet Please see my comment above.  "In the web acquisition experience of SSDT, only the database project component is included (SSIS/AS/RS are not)."

Page 1 of 3 (43 items) 123