SQL Server Data Tools Team Blog

Official team blog for SSDT, a tool for on- and off-premises database development

SQL Server Data Tools GA update for June 2016

The SQL Server Data Tools team is pleased to announce an update for SSDT General Availability (GA) is now released. The SSDT GA update for June 2016 added support for the latest updates of SQL Server 2016 RTM, various bug fixes.

SQL Server Data Tools Preview update for April 2016

The SQL Server Data Tools team is pleased to announce an update for SSDT Preview is now available. The SSDT Preview update for April 2016 added support for the latest updates of SQL Server 2016 RC3, various bug fixes.
 
Get it here:
Download SSDT April 2016 Preview for Visual Studio 2015 and Visual Studio 2013

The version number for the latest preview in Visual Studio 2015 is 14.0.60413.0
The version number for the latest preview in Visual Studio 2013 is 12.0.60413.0

Download Data-Tier Application Framework April 2016 Preview

The version number for the latest preview is 13.0.3293.1

 

Part 3. Create Nuget package for Azure SQL Database

This blog is part 3 of Automate Build and Deployment of Azure SQL Database with Continuous Integration and Continuous Deployment.
Content of Tutorial:
Part 1. Prerequisite for Azure SQL Database Build and Deployment Automation
Part 2. Automate Building Azure SQL Database with Continuous Integration
Part 3.

Uncategorized

Announcing the General Availability (GA) Release of SSDT 17.0 (April 2017)

We are pleased to announce that SQL Server Data Tools 17.0 is officially released and supported for production use. This GA release includes support for SQL Server 2017 and SQL Server on Linux including new features such as Graph DB. It includes several features that we have consistently received requests for via MSDN forums and Connect and contains numerous fixes and improvements over the 16.x version of the tools.

SQL Server Data Tools 17.0 RC, and SSDT in VS2017

It’s been a busy few months for SSDT with multiple Release Candidate releases of the 17.0 major release, and Visual Studio 2017 shipping this week. Here’s a quick update on the latest & greatest database tools updates you can try out.

SQL Server Data Tools 16.5 Release

The SQL Server Data Tools team is pleased to announce an update for SQL Server Data Tools (SSDT) is now available. The SSDT 16.5 release adds a number of improvements to the connection experience, SqlPackage and DacFx API support for generating a deployment report and scripts during publish,

SQL Server Data Tools 16.4 Release

The SQL Server Data Tools team is pleased to announce an update for SQL Server Data Tools (SSDT) is now available. The SSDT 16.4 release adds support for Schema Compare in SqlPackage.exe and as an API, Integrated Workspace Mode for SSDT Tabular,

Schema Compare in SqlPackage and the Data-Tier Application Framework (DACFx)

In the most recent version of SqlPackage.exe and the Data-Tier Application Framework (DACFx), we have introduced some new functionality: Schema Compare! A couple of years ago we added MSBuild support for Schema Compare.  We’ve now extended that support to SqlPackage.exe and DACFx.

SqlPackage.exe: How to get detailed information about supported parameters

Recently we have received questions about sqlpackage.exe and its supported parameters. In this blog I will share a simple tip to get the help information about all supported parameters and properties for a specific action from the version of sqlpackage.exe that you use.

Releasing SSDT with Visual Studio “15” Preview 4 and introducing SSDT MSBuild NuGet package

Today marks the release of Visual Studio “15” Preview 4. The SQL Server Data Tools team is happy to announce support for the relational database set of SQL tools – SQL Projects, Schema Compare, Data Compare, and SQL Server Object Explorer –

Part 5. Use your own Build and Deployment Agent

This blog is part 5 of Automate Build and Deployment of Azure SQL Database with Continuous Integration and Continuous Deployment.
Content of Tutorial:
Part 1. Prerequisite for Azure SQL Database Build and Deployment Automation
Part 2. Automate Building Azure SQL Database with Continuous Integration
Part 3.

SQL Server Data Tools 16.3 Release

The SQL Server Data Tools team is pleased to announce an update for SQL Server Data Tools (SSDT) is now available. The SSDT 16.3 release introduces new Tabular Model Explorer, enhancements for Always Encrypted experience with new key management dialogs and various bug fixes.

SQL Server Data Tools July Update

The SQL Server Data Tools team is pleased to announce an update for SQL Server Data Tools (SSDT) is now available. The SSDT update for July 2016 adds bug fixing and enhanced support for SQL Server 2016 features such as Always Encrypted and Temporal Table.