Skip to content

Commit b378c0e

Browse files
dzsquareddzsquared
committed
release notes draft
1 parent 8f4d14e commit b378c0e

3 files changed

Lines changed: 57 additions & 8 deletions

File tree

‎docs/tools/sqlpackage/release-notes-sqlpackage.md‎

Lines changed: 50 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ description: Release notes for Microsoft SqlPackage.
44
author: dzsquared
55
ms.author: drskwier
66
ms.reviewer: "llali"
7-
ms.date: 2/13/2023
7+
ms.date: 5/10/2023
88
ms.service: sql
99
ms.topic: conceptual
1010
ms.custom: tools|sos
@@ -15,6 +15,55 @@ ms.custom: tools|sos
1515

1616
This article lists the features and fixes delivered by the released versions of SqlPackage.
1717

18+
19+
## 162.xxxx.0 SqlPackage
20+
21+
**Release date:** February 13, 2023
22+
23+
|Platform|Download|Version|
24+
|:---|:---|:---|
25+
|Windows .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2224909)|162.0.xxxx.0|
26+
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2224908)|162.0.xxxx.0|
27+
|macOS .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2225106)|162.0.xxxx.0|
28+
|Linux .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2225105)|162.0.xxxx.0|
29+
30+
31+
### Features
32+
| Feature | Details |
33+
| :------ | :------ |
34+
|Platform|SqlPackage now collects usage data, including anonymous feature usage and diagnostic data. For more information, see [Usage data collection](sqlpackage.md#usage-data-collection).|
35+
|Platform|References [Microsoft.Data.SqlClient](https://www.nuget.org/packages/Microsoft.Data.SqlClient/5.1.0) v5.1.0|
36+
|Azure Synapse Analytics|Adds support for [DW_COMPATIBILITY_LEVEL](../../t-sql/statements/alter-database-scoped-configuration-transact-sql.md#dw_compatibility_level---auto--10--20--30--40--50--9000).|
37+
|ScriptDOM|ScriptDOM is now available as a standalone package on [NuGet](https://www.nuget.org/packages/Microsoft.SqlServer.TransactSql.ScriptDom) and is open source on [GitHub](https://github.com/microsoft/SqlScriptDOM).|
38+
|System dacpacs|The `master` and `msdb` system dacpacs are now available on [NuGet](https://www.nuget.org/packages/Microsoft.SqlServer.Dacpacs). More information on the system dacpacs and consuming dacpacs as a package reference is available in the [DacFx GitHub repository](https://github.com/microsoft/DacFx).|
39+
40+
### Fixes
41+
| Feature | Details |
42+
| :------ | :------ |
43+
|Azure Synapse Analytics|Fixes an issue where the default command timeout was not set properly when connecting to Azure Synapse Analytics serverless SQL pools.|
44+
|Azure Synapse Analytics|Fixes an issue where Azure Synapse Analytics serverless SQL pools would incorrectly determine the default data and log paths.|
45+
|Azure Synapse Analytics|Fixes an issue where Azure Synapse Analytics serverless SQL pools would incorrectly determine the default login, user and schema.|
46+
|Azure SQL Database|Fixes an issue where temporal history retention was not correctly recognized as not configured (null).|
47+
|Deployment|Fixes an issue where the deployment plan fails to detect a dependency on a table/view in subqueries within FROM VALUES clause. [GitHub issue](https://github.com/microsoft/DacFx/issues/156)|
48+
|Deployment|Fixes an issue where deployment would fail when the target database contains a rule bound to a column.|
49+
|Deployment|Fixes an issue where deployment would fail when the target database contains a rule bound to a column with a user-defined type.|
50+
|Deployment|Fixes an issue where the retention period on a temporal table would be reset to the default value when another change is made to the table.|
51+
|Deployment|Fixes an issue where updates to a primary key is not included in the deployment when the table has compression options specified.|
52+
|Deployment|Fixes an issue where a non-clustered index on a partitioned table is rebuilt even when no changes are made to the table. [GitHub issue](https://github.com/microsoft/DacFx/issues/202)|
53+
|Deployment|Fixes an issue where ignorecolumnorder property is not honored by a history table when no changes are made to a system-versioned table except the columns are reordered.|
54+
|Export|Fixes an issue where the diagnostic information provided during an export operation incorrectly reports the size of a table in KB instead of Bytes. [GitHub issue](https://github.com/microsoft/DacFx/issues/209)|
55+
|Ledger|Fixes an issue where SqlPackage was not correctly identifying the error when the Ledger history table or view have an invalid two-part name.|
56+
|Query Store|Fixes an issue where the `flush_interval_seconds` [Query Store option](../../relational-databases/system-catalog-views/sys-database-query-store-options-transact-sql.md) was not correctly validated with a minimum value of 60 seconds.|
57+
|SQL Server 2022|Fixes an issue where the function `DATETRUNC` was not recognized as a built-in function. [Developer Community report](https://developercommunity.visualstudio.com/t/Visual-Studio-build-solution-not-recogni/10333180)|
58+
|SQL Server 2022|Fixes an issue where the function `DATE_BUCKET` was not recognized as a built-in function.|
59+
60+
61+
### Known Issues
62+
| Feature | Details | Workaround |
63+
| :------ | :------ |:------ |
64+
| Deployment | The Azure Synapse Analytics Workload Management feature (Workload Groups and Workload Classifiers) isn't yet supported. | N/A |
65+
| ScriptDOM | Parsing a very large file can result in a stack overflow. | None |
66+
1867
## 161.8089.0 SqlPackage
1968

2069
**Release date:** February 13, 2023

‎docs/tools/sqlpackage/sqlpackage-download.md‎

Lines changed: 6 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ description: "Download and Install SqlPackage for Windows, macOS, or Linux"
44
author: "dzsquared"
55
ms.author: "drskwier"
66
ms.reviewer: "maghan"
7-
ms.date: 2/13/2023
7+
ms.date: 5/10/2023
88
ms.service: sql
99
ms.subservice: tools-other
1010
ms.topic: conceptual
@@ -17,14 +17,14 @@ ms.custom:
1717

1818
SqlPackage runs on Windows, macOS, and Linux, and is available to install through `dotnet tool` or as a standalone zip download.
1919

20-
- **Version number:** 161.8089.0
21-
- **Build number:** 16.1.8089.0
22-
- **Release date:** February 13, 2023
20+
- **Version number:** 162.0.xxxx.0
21+
- **Build number:** 162.0.xxxx.0
22+
- **Release date:** May 10, 2023
2323

2424
For details about the latest release, see the [release notes](release-notes-sqlpackage.md).
2525

2626
> [!NOTE]
27-
> SqlPackage version numbering has been adjusted to better reflect the DacFx build number it is associated with. Previously, SqlPackage had a distinct version number (19) and build number (160.x). Beginning with version 161, the version number of SqlPackage will match the DacFx version number it is associated with (eg 161.8089.0).
27+
> SqlPackage version numbering has been adjusted to better reflect the DacFx build number it is associated with. Previously, SqlPackage had a distinct version number (19) and build number (160.x). Beginning with version 161, the version number of SqlPackage will match the DacFx version number it is associated with (eg 162.0.xxxx.0).
2828
2929
## Installation, cross-platform
3030

@@ -168,7 +168,7 @@ Evergreen links are available for downloading the latest Sqlpackage versions:
168168

169169
## DacFx
170170

171-
SqlPackage is a command-line interface for the DacFx framework, exposing some of the public DacFx APIs. DacServices ([Microsoft.SqlServer.Dac](/dotnet/api/microsoft.sqlserver.dac.dacservices)) is a related mechanism for integrating database deployment into your application pipeline. The DacServices API is available in a package through NuGet, [Microsoft.SqlServer.DacFx](https://www.NuGet.org/packages/Microsoft.SqlServer.DacFx). The current DacFx version is 161.8089.0.
171+
SqlPackage is a command-line interface for the DacFx framework, exposing some of the public DacFx APIs. DacServices ([Microsoft.SqlServer.Dac](/dotnet/api/microsoft.sqlserver.dac.dacservices)) is a related mechanism for integrating database deployment into your application pipeline. The DacServices API is available in a package through NuGet, [Microsoft.SqlServer.DacFx](https://www.NuGet.org/packages/Microsoft.SqlServer.DacFx). The current DacFx version is 162.xxxx.0.
172172

173173
Adding the NuGet package to a .NET project is accomplished via the .NET CLI with this command:
174174

‎docs/tools/sqlpackage/sqlpackage.md‎

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ description: Learn how to automate database development tasks with SqlPackage. V
44
author: "dzsquared"
55
ms.author: "drskwier"
66
ms.reviewer: "maghan"
7-
ms.date: 6/1/2022
7+
ms.date: 5/10/2023
88
ms.service: sql
99
ms.subservice: tools-other
1010
ms.topic: conceptual

0 commit comments

Comments
 (0)