Microsoft releases SQL Server Data Tools version 16.4

2 min. read

Published onSeptember 20, 2016

published onSeptember 20, 2016

Share this article

Read our disclosure page to find out how can you help Windows Report sustain the editorial teamRead more

On the more technical side of news, the SQL Server Data Tools (SSDT) team hasannouncedtheir most recent update to 16.4.

The update to 16.4 is making Schema Compare supported in SqlPackage.exe. It will also be supported by the Data-Tier Application Framework API. It was clarified in theSSDT team blogcorresponding with the update that files created in Visual Studio with Schema Compare (.scmp) will now be accepted. The files can now be created, loaded, compared, and otherwise used now by the Data-Tier Application Framework API.

The Schema Compare file specifies the source and target, which can be either a database or a dacpac file. Note: Schema Compare files that have a database project as the source or target are not supported at this time. Your schema compare file can, though, reference the dacpac file from your database project’s build output.

Another major feature of the update was the addition of the Integrated Workspace Mode for SSDT Tabular. This analysis service makes it possible to create and organize data internally. They’ve even made it easy to switch tabular projects on explicit work space servers over to the new feature so that you can continue your task without much hassle. More details were released on theAnalysis Services and PowerPivot Team Blog:

In integrated workspace mode, SSDT Tabular dynamically starts its internal SSAS instance in the background and loads the database so that you can add and view tables, columns, and data in the model designer, and if you add additional tables, columns, relationships, and so forth, you are automatically modifying the workspace database, as well. 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.

The update also came with a vast amount of bug fixes and improvements for database tools and analysis reporting services.

You can download the SSDT 16.4 for Visual Studio from theSQL Server Tools library. Likewise, the Data-Tier Application Framework 16.4 is available from theDownload Center.

Radu Tyrsina

Radu Tyrsina has been a Windows fan ever since he got his first PC, a Pentium III (a monster at that time).

For most of the kids of his age, the Internet was an amazing way to play and communicate with others, but he was deeply impressed by the flow of information and how easily you can find anything on the web.

Prior to founding Windows Report, this particular curiosity about digital content enabled him to grow a number of sites that helped hundreds of millions reach faster the answer they’re looking for.

User forum

0 messages

Sort by:LatestOldestMost Votes

Comment*

Name*

Email*

Commenting as.Not you?

Save information for future comments

Comment

Radu Tyrsina

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low#

Copilot in Outlook will generate personalized themes for you to customize the app#

Microsoft will raise the price of its 365 Suite to include AI capabilities#

Death Stranding Director’s Cut is now Xbox X|S at a huge discount#

Outlook will let users create custom account icons so they can tell their accounts apart easier#

Microsoft releases SQL Server Data Tools version 16.4#

With KB5043178 to Release Preview Channel, Microsoft advises Windows 11 users to plug in when the battery is low

Copilot in Outlook will generate personalized themes for you to customize the app

Microsoft will raise the price of its 365 Suite to include AI capabilities

Death Stranding Director’s Cut is now Xbox X|S at a huge discount

Outlook will let users create custom account icons so they can tell their accounts apart easier

Microsoft releases SQL Server Data Tools version 16.4