SQL Server Data Tools in Visual Studio 2012

  • Article
Number 1 icon

Software Requirements

  • If you already have the Professional, Ultimate, or Premium Edition of Visual Studio 2012 and didn't opt out of installing SQL Server Data Tools (SSDT) during setup, then your machine has an existing installation of SSDT. Installing this update will replace these SSDT bits with a newer version.
  • If you do not have Visual Studio 2012 Professional Edition or above, SSDT will install the Visual Studio 2012 Integrated Shell 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. The database functionality of Express SKUs of Visual Studio 2012 will also be updated when SSDT is installed.

Supported Operating Systems

  • Windows 10 (x86 and x64)
  • Windows 8, 8.1 (x86 and x64)
  • Windows 7 SP1 (x86 and x64)
  • Windows Server 2012 (x64), R2 (x64)
  • Windows Server 2008 R2 SP1 (x64)
Number 2 icon

Download and Install SQL Server Data Tools
Number 3 icon

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) https://go.microsoft.com/fwlink/?LinkID=617314&clcid=0x416
    Chinese (PRC) https://go.microsoft.com/fwlink/?LinkID=617314&clcid=0x804
    German https://go.microsoft.com/fwlink/?LinkID=617314&clcid=0x407
    English (United States) https://go.microsoft.com/fwlink/?LinkID=617314&clcid=0x409
    Spanish https://go.microsoft.com/fwlink/?LinkID=617314&clcid=0x40a
    French https://go.microsoft.com/fwlink/?LinkID=617314&clcid=0x40c
    Italian https://go.microsoft.com/fwlink/?LinkID=617314&clcid=0x410
    Japanese https://go.microsoft.com/fwlink/?LinkID=617314&clcid=0x411
    Korean https://go.microsoft.com/fwlink/?LinkID=617314&clcid=0x412
    Russian https://go.microsoft.com/fwlink/?LinkID=617314&clcid=0x419
    Chinese (Taiwan) https://go.microsoft.com/fwlink/?LinkID=617314&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.
Number 4 icon

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-contained 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 downloaded, the ISO can be mounted as a drive or burned to a DVD.

Portuguese (Brazil) VS 2012 component update ISO - BR
Chinese (PRC) VS 2012 component update ISO - CN
German VS 2012 component update ISO - DE
English (United States) VS 2012 component update ISO - EN
Spanish VS 2012 component update ISO - ES
French VS 2012 component update ISO - FR
Italian VS 2012 component update ISO - IT
Japanese VS 2012 component update ISO - JA
Korean VS 2012 component update ISO - KO
Russian VS 2012 component update ISO - RU
Chinese (Taiwan) VS 2012 component update ISO - TW