Release Notes

Microsoft.SqlServer.DacFx 170.5.60-preview

This update brings the below changes over the previous release:

Adds editing of VECTOR column dimensions and base type in Table Designer
Adds support for VECTOR column dimensions and base types in table-valued parameters and function return types
Adds support for LogDeployment (T/F) and EnableFastComparison (T/F) publish properties, which leverage an automatically managed table dbo.__DacFxDeploymentHistory in the target database to track "DacVersions". Fast comparison assumes no drift between last deployment and current state. New SQLCMD variable DacVersion_Previous is determined based on the contents of dbo.__DacFxDeploymentHistory when LogDeployment publish property is set to true.

Fixes generation of an incorrect drop statement for unnamed default constraints #807
Fixes non-deterministic object ordering when creating and updating a SQL project #795
Fixes a redundant ALTER TABLE ... ADD CONSTRAINT emitted when publishing inline constraints from a project #792
Fixes an InvalidCastException when extracting an object-level permission on a SECURITY POLICY #800
Fixes a large BACPAC export failing with a "Stream was too long" overflow on System.IO.Packaging
Fixes a SQL72008 build error when pre/post-deploy scripts reference $(DacVersion) / $(DacVersion_Previous)
Fixes BACPAC export of Always Encrypted large fixed-length columns
Fixes VECTOR_SEARCH table alias and distance column resolution in SQL project build
Fixes reverse engineering of external languages failing on SQL Managed Instance due to an is_system_language bind failure
Fixes Schema Compare emitting redundant child-element scripts for inline-scriptable elements
Fixes sp_addextendedproperty with @level1type=N'NULL' for an extended property on a SECURITY POLICY
Fixes Table Designer identity default validation
Fixes stale Table Designer cache access token callbacks
Fixes error message location format to use (line,col) instead of (line,col,line,col)