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

SQL Server Data Tools RTM update for July 2015

The SQL Server Data Tools team is pleased to announce an update for SSDT RTM is now available. Visual Studio 2015 was released to manufacturing (RTM) on July 20 and this update fully supports Visual Studio 2015 along with 2013 and 2012. The SSDT RTM update for July 2015 includes fixes for customer-reported issues from the… Read more

DacFx Public Model Tutorial

Recently there has been an increasing interest in extending the capabilities of SSDT and DacFx. The walkthrough guides for creating new build and deployment contributors and database unit test conditions are a useful start in exploring the tools, but they only scratch the surface of what’s possible. They also don’t really show the best practices… Read more