Skip to main content

SQL Server Data Tools - December 2012 update

(Visual Studio 2010)

Software Requirements

  • If you already have the Professional Edition or higher of Visual Studio 2010, SSDT will integrate into your existing VS environment. Please note that you must install SP1 manually before installing SSDT.
  • If you do not have Visual Studio 2010 Professional Edition or above, SSDT will install the Visual Studio 2010 Integrated Shell, apply SP1, and install SSDT on top of it. The Integrated Shell will only contain SSDT, and does not include VS programming languages and the features that support their respective project systems.

Supported Operating Systems

  • Windows Vista SP2 or above
  • Windows 7 SP1 or above
  • Windows 8 RTM
  • Windows Server 2008 SP2 or above
  • Windows Server 2008 R2 SP1 or above

Download and Install SQL Server Data Tools

Upgrade Data-Tier Application Framework (DACFx)

A new version of the SQL Server Data-Tier Application Framework (May 2013, version 11.1.2825.1) has been released since the availability of the SSDT December 2012 update. This release of DACFx contains a critical bug fix, which is covered in more detail in the following blog post: SQL Server Data-Tier Application Framework (May 2013) Available. The new version of DACFx is fully compatible with the December 2012 release of SQL Server Data Tools for Visual Studio 2012.

Set up an Administrative Install Point (optional)

For locations without internet access, create an Administrative Install Point for SQL Server Data Tools by following this procedure:

  1. Download the appropriate version of SSDTSetup.exe for your chosen language from the table below (use the “save” option in your browser, rather than “run”):
    Portuguese (Brazil) http://go.microsoft.com/fwlink/?LinkID=274981&clcid=0x416
    Chinese (PRC) http://go.microsoft.com/fwlink/?LinkID=274981&clcid=0x804
    German http://go.microsoft.com/fwlink/?LinkID=274981&clcid=0x407
    English (United States) http://go.microsoft.com/fwlink/?LinkID=274981&clcid=0x409
    Spanish http://go.microsoft.com/fwlink/?LinkID=274981&clcid=0x40a
    French http://go.microsoft.com/fwlink/?LinkID=274981&clcid=0x40c
    Italian http://go.microsoft.com/fwlink/?LinkID=274981&clcid=0x410
    Japan http://go.microsoft.com/fwlink/?LinkID=274981&clcid=0x411
    Korean http://go.microsoft.com/fwlink/?LinkID=274981&clcid=0x412
    Russian http://go.microsoft.com/fwlink/?LinkID=274981&clcid=0x419
    Chinese (Taiwan) http://go.microsoft.com/fwlink/?LinkID=274981&clcid=0x404
  2. Once downloaded, run the following command using an administrator command prompt (cmd.exe run as administrator):

    SSDTSetup.exe /layout <destination>

    Where <destination> is the location you wish to create the administrative install point (e.g on a USB drive, a LAN drive or other accessible location). NOTE: You will need approximately 1.8GB of free space at for the full install point because it includes all possible components that might be required.
  3. To use the install point once created, simply run SSDTSetup.exe from the <destination> location with no arguments. This will use the install point rather than attempting to download new copies of the relevant chained components.

Download SSDT as an ISO image (optional)

An ISO image of SSDT can be used as an alternative way to install SSDT or to set up an Administrative Installation point. The ISO is a self-containted file that contains all of the components needed by SSDT and it can be downloaded using a restartable download manager, useful for situations with limited or less reliable network bandwidth. Once download, the ISO can be mounted as a drive or burned to a DVD.

Portuguese (Brazil) SSDTDec2012_VS2010_BR.iso
Chinese (PRC) SSDTDec2012_VS2010_CN.iso
English (United States) SSDTDec2012_VS2010_EN.iso
French SSDTDec2012_VS2010_FR.iso
German SSDTDec2012_VS2010_DE.iso
Italian SSDTDec2012_VS2010_IT.iso
Japanese SSDTDec2012_VS2010_JA.iso
Korean SSDTDec2012_VS2010_KO.iso
Russian SSDTDec2012_VS2010_RU.iso
Spanish SSDTDec2012_VS2010_ES.iso
Chinese (Taiwan) SSDTDec2012_VS2010_TW.iso