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