SQL Server Data Tools - 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

• Download SQL Server Data Tools for Visual Studio 2010

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