Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

This download of SQL Server Data Tools is an English only pre-release version. This preview may not work the way a final version of the software will and does not guarantee to support upgrade. Do not use this preview software in a live operating environment. For more information, refer to the License Terms installed by this preview software.

This update adds support to SQL Server Database Tooling in Visual Studio 2013 for the latest Microsoft Azure SQL Database Update V12 (Preview):

• Support for new features added in the latest Azure SQL Database Update V12 (preview). For details about what’s new, please refer to http://azure.microsoft.com/en-us/documentation/articles/sql-database-preview-whats-new.
• Improved reliability when targeting Basic and Standard Performance Tiers in Microsoft Azure SQL Databases.
• SQL Server Object Explorer supports creating, editing and browsing all database objects located in your Azure SQL Database, including support for the latest features added in Azure SQL Database Update V12 (Preview).
• SQL Server Database Project support for targeting Azure SQL Database Update V12 (preview). The project system supports build-time validation, compilation, refactoring, and support for incremental deployment to SQL Server databases. Now all the great features added in Azure SQL Database Update V12 can be modeled in your database project.
• Ability to migrate existing on-premise databases to Azure SQL Database including to databases supporting the latest Azure SQL Database Update V12 (preview) features, and develop and maintain databases across both on-premise and cloud deployments.
• Schema Compare now has improved support for comparing databases, projects and dacpacs across different SQL Server platforms. Script/update operations are deployable to a different target platform if all source objects are compatible with the target platform. Comparison between on-premises and Azure SQL Databases is now allowed by default.
• Data Compare support for Azure SQL Database Update V12 (preview). Please note that using Data Compare against Azure SQL Databases will incur bandwidth charges, and as such, is not recommended for use with large databases.
• Support for the latest Azure SQL Database Update V12 (preview) when using the SQL Server Data-Tier Application Framework APIs.
• SQLPackage.exe enhancements to support the latest Azure SQL Database Update V12 (preview). Please refer to SQLPackage.exe documentation for full details.
  
  Enhancements include:
  • Improved working experience against Azure SQL Database Basic and Standard Editions with increased default CommandTimeout value.
  • Ability to specify CommandTimeout value in SQLPackage.exe. Note that for deployments to Azure SQL Databases, if this value is lower than the new default timeout for Azure SQL Databases then the default value will be used instead.
  • Ability to specify Azure SQL Database version during export.
  • Ability to specify Azure SQL Database edition, service objective and maximum size for publish and import action. You will also need to apply cumulative update package 5 for SQL Server 2014 available here to be able to use the service objective support.

We appreciate all feedback and encourage use of our forum or Microsoft Connect site.

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to January 2019.

No files found

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• Computer with Intel or compatible 1.6 GHz or faster processor (2 GHz or faster is recommended.)
• Minimum of 1 GB of RAM (2 GB or more is recommended.)

This update can only be applied to an existing installation of Visual Studio 2013 Professional, Premium, Ultimate, Express for Web, or Express for Windows Desktop.

• Close any open instances of Visual Studio 2013 before installation
• Launch SSDTSetup.exe by either
  • Downloading the software from Download Center and starting the SSDTSetup.exe file from your download location, or
  • Running the SSDTSetup.exe directly from download center
• Follow the installation wizard to install
• If Visual Studio was open during installation, it must be restarted or errors will occur in the SQL Server database features

Alternatively, you can also make an administrative install.

• 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
• 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.