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. This includes a fix for Connect Issue 3104154 to ensure Database Unit Tests work as expected.
Get it here:
- The version number for GA in Visual Studio 2015 is 14.0.60923.0 (Direct link: https://msdn.microsoft.com/en-us/mt186501)
- The version number for GA in Visual Studio 2013 is 12.0.60923.0 (Direct link: https://msdn.microsoft.com/en-us/dn864412)
This release will be available through Visual Studio Extensions and Updates notification soon.
- The version number is 13.0.3450.1
- You can also install as a nuget package, e.g. for use in Powershell or your own app integration scenarios:
What’s new in SSDT?
Schema Compare is now supported in SqlPackage.exe and the Data-Tier Application Framework (DacFx) API. To learn more please read Schema Compare in SqlPackage and the Data-Tier Application Framework.
Analysis Services – Integrated Workspace Mode for SSDT Tabular (SSAS)
SSDT Tabular now includes an internal SSAS instance, which SSDT Tabular starts automatically in the background if integrated workspace mode is enabled so that you can add and view tables, columns, and data in the model designer without having to provide an external workspace server instance. Integrated workspace mode does not change how SSDT Tabular works with a workspace server and database. What changes is where SSDT Tabular hosts the workspace database. To enable integrated workspace mode, select the Integrated Workspace option in the Tabular Model Designer dialog box displayed when creating a new tabular project. For existing tabular projects that currently use an explicit workspace server, you can switch to integrated workspace mode by setting the Integrated Workspace Mode parameter to True in the Properties window, which is displayed when you select the Model.bim file in Solution Explorer.
For more information please read this Analysis Services blog post.
Fixed / Improved this month
Connect Issue 3104154 – Database Unit Test fails after installing SSDT 16.4
Analysis Services & Reporting Services
|Fixed an issues in SSDT where error tip pop ups where in the way when editing DAX for DirectQuery calculated columns|
|Fixed an issue in SSDT AS tabular grid where the KPI Icon wasn’t showing in measure grid when Windows scaling factor set at high-DPI 200%+|
|Fixed an issue in SSDT AS where pasting large table data could make the tabular project unresponsive|
|Fixed an issue in SSDT AS tabular model editor to mark the model as needing to save changes when renaming connection friendly name|
|Fixed an issue in the SSDT AS tabular projects where width of columns in the manage relationships dialog could not be resized|
|Fixed an issue in SSDT AS tabular 1200-level models where pasting data from Excel with locale settings like German didn’t treat the comma as the decimal separator correctly|
|Fixed an issue in SSDT AS projects with some KPI icon sets which could yield an error “Couldn’t retrieve the data for this visual.”|
|Fixed an issue with SSDT AS project properties dialog to anchored correctly when resized at High-DPI scaling|
|Fixed an issue in SSDT AS projects that may have caused an error upgrading certain models with Pasted tables|
|Fixed an issue in SSDT AS where pasting full sheet rows from Excel was very slow and created many unwanted columns|
|Fixed an issue in SSDT AS where large static DataTable expressions parsing and highlight was really slow or appeared to hang|
|Fixed an issue in SSDT AS to add measures and KPI values to the current perspective selected in the editor|
|Fixed an issue in SSDT where data import into AS project from SQL Azure didn’t support schema types other than “dbo.”|
If you have any question or feedback, please ping @sqldatatools on twitter, visit our forum and for bugs please create bug reports on our Microsoft Connect page. We are fully committed to improve the SSDT experience and look forward to hearing from you!