You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Fixed a bug with deploying to [!INCLUDE fabric-sqldb] when the target database includes a security policy.
SqlPackage CLI; DacFx API / Schema compare
Export
Fixed an issue where exported .dacpac files fail XSD schema validation due to boolean attribute values using True/False values instead of lowercase true/false. GitHub issue
SqlPackage CLI
Import
Fixed an issue where importing a table with special characters in the name (such as /, ", or $) silently fails to import data without warning the user. GitHub issue
SqlPackage CLI
Ledger
Fixed an issue where a ledger table with a computed column causes a NullReferenceException during model validation and build. GitHub issue
MSBuild / SQL projects; DacFx API / Schema compare
SQL projects
Fixed an issue where building a SQL project with an inline clustered columnstore index definition on a table fails with a syntax error. GitHub issue
MSBuild / SQL projects
SQL projects
Fixed an issue where a clustered columnstore index on a table with NVARCHAR(MAX) or other LOB-type columns incorrectly reports an error that columnstore indexes aren't supported with vector columns. GitHub issue
MSBuild / SQL projects
Vector
Fixed an issue where procedures using VECTOR_SEARCH report a validation warning that the column reference couldn't be resolved. GitHub issue
MSBuild / SQL projects; DacFx API / Schema compare
Added support for external models in [!INCLUDE ssazure-sqldb] and [!INCLUDE sssql25-md] for import, export, extract, deployment, and SQL project build.
Added support for the vector indexes in [!INCLUDE ssazure-sqldb] and [!INCLUDE sssql25-md] for import, export, extract, deployment, and SQL project build.
Fixed an issue where the XML query path (xQuery) wasn't treated as case-sensitive during model comparison. Even on case-insensitive databases, the xQuery path is case-sensitive. GitHub issue
Added support for publish properties /p:IgnorePreDeployScript and /p:IgnorePostDeployScript. These properties default to false and when enabled result in the deployment plan omitting the corresponding scripts. GitHub issue
SqlPackage CLI; DacFx API / Schema compare
Permissions
Added support for the permission ALTER ANY EXTERNAL MIRROR for [!INCLUDE ssazure-sqldb] and [!INCLUDE fabric-sqldb]. This permission is required to export a database that contains one or more mirrored tables. GitHub issue
SqlPackage CLI; DacFx API / Schema compare
Permissions
Added support for the permissions CREATE ANY EXTERNAL MODEL and ALTER ANY EXTERNAL MODEL for [!INCLUDE sssql25-md].
SqlPackage CLI; DacFx API / Schema compare
Permissions
Added support for the permission ALTER ANY INFORMATION PROTECTION for [!INCLUDE sssql25-md] and [!INCLUDE ssazure-sqldb].
SqlPackage CLI; DacFx API / Schema compare
Platform
The SqlPackage .zip build .NET SDK is updated to 8.0.412.
Platform; SqlPackage CLI
ScriptDom
Updated ScriptDom to version 170.0.64.
Platform
ScriptDom
Updates the Data warehouse in Fabric platform to use the TSqlFabricDWParser in ScriptDom.
Platform; DacFx API / Schema compare
Fixes
Feature
Details
Applies to
Always Encrypted
Fixed an issue where the Interactive option for the /AzureKeyVaultAuthMethod publish parameter wasn't working correctly.
SqlPackage CLI
Deployment
Fixed an issue where the DbScopedConfigMaxDOPSecondaryproperty wasn't set correctly in the deployment. GitHub issue
SqlPackage CLI; DacFx API / Schema compare
Deployment
Fixed an issue where publishing tables containing foreign key constraints fails with syntax not supported in Data warehouse in Microsoft Fabric.
SqlPackage CLI
Deployment
Fixed an issue where server objects were included when deploying to [!INCLUDE fabric-sqldb]. Server objects aren't supported in [!INCLUDE fabric-sqldb]. GitHub issue
SqlPackage CLI
Deployment
Fixed an issue where clustered columnstore indexes are created by first creating a clustered index, which increases deployment overhead and time. GitHub issue
SqlPackage CLI
Extract
Fixed an issue where extracting a database from [!INCLUDE fabric-sqldb] results in unusable user definition scripts. GitHub issue
Support for verifying the contents of two .dacpac files is added in the preview tool Microsoft.DacpacVerify.
DacFx API / Schema compare
Extract
Added support for unpacking a .dacpac file to a folder. The /Action:Extract command is used with /SourceFile: and /TargetFile: parameters. The target file must be a folder and when a source file (.dacpac) is specified no database connection properties are valid. The property /p:ExtractTarget=SchemaObjectType is required for extracting from a .dacpac file instead of a source database. The executable Dacunpack.exe is removed from the DacFx.msi installer.
SqlPackage CLI; DacFx API / Schema compare
Parquet
Added support for the data types timestamp, rowversion, uniqueidentifier, text, ntext, image, json, xml, and vector when using Parquet files in Azure Blob Storage with SqlPackage extract and publish operations.
SqlPackage CLI
Parquet
Added support for exporting and importing table data to BCP files when the table contains an unsupported data type while using Parquet files in Azure Blob Storage for the remaining data with SqlPackage extract and publish operations. An example data type is sql_variant, and a table containing a column of that type is written to BCP in the .dacpac while the remaining tables are written to Parquet files in Azure Blob Storage.
SqlPackage CLI
Platform
Updated SqlPackage for .NET Framework version to .NET Framework 4.7.2.
Fixed an issue where deploying a change to an external table causes all external tables to be dropped and recreated if the modified table contained no values for REJECT_VALUE or REJECT_SAMPLE_VALUE.
SqlPackage CLI; DacFx API / Schema compare
Deployment
Fixed an issue where altering a column to expand its length results in an incorrect data loss warning if the column's collation is specified and matches the database default collation. GitHub issue
SqlPackage CLI; DacFx API / Schema compare
Deployment
Fixed an issue where sensitivity classification changes on a table cause indexes to be recreated. GitHub issue
SqlPackage CLI; DacFx API / Schema compare
Export
Optimized the use of table size estimation during export operations.
SqlPackage CLI
Extract
Fixed an issue where extracting a .dacpac with a database reference fails. GitHub issue
SqlPackage CLI; DacFx API / Schema compare
Fabric Data Warehouse
Fixed an issue where the sp_refreshsqlmodule system stored procedure is called during a publish operation. Fabric Data Warehouse doesn't support sp_refreshsqlmodule and this causes the deployment to fail.
SqlPackage CLI
Fabric Data Warehouse
Fixed an issue where table constraints are included in a .dacpac but not .sql files when a database was extracted from a Fabric Data Warehouse. GitHub issue
SqlPackage CLI
SQL projects
Fixed an issue where building without SSDT installed in Visual Studio results in incorrect build behavior. GitHub issue
MSBuild / SQL projects
SQL projects
Fixed an issue where build warnings are duplicated in output when code analysis is enabled. GitHub issue