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, and as usual a number of bug… Read more

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, and as usual has various bug fixes. Update: SSDT 16.4.1 Hotfix release is available…. Read more

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 SqlPackage.exe’s Publish and Script actions now accept Schema Compare (.scmp) files created by Visual… Read more

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. For each action type, copy and execute the command below. For Export: sqlpackage.exe… Read more

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 – in this Visual Studio release. This release includes a great number of new… Read more

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. Create NuGet package for Azure SQL Database Part 4. Orchestrate Azure SQL… Read more

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. Get it here: Download SSDT GA 16.3 for Visual Studio 2015 and Visual Studio… Read more

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. This update also introduces a ‘safe installation‘ experience. It aims to guarantee the installation… Read more

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.   Get it here: Download SSDT GA June 2016 for Visual Studio 2015 and Visual Studio 2013 The… Read more