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
|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).|
|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 as [Microsoft.SqlServer.Dacpacs.Master](https://www.nuget.org/packages/Microsoft.SqlServer.Dacpacs.Master) and [Microsoft.SqlServer.Dacpacs.Msdb](https://www.nuget.org/packages/Microsoft.SqlServer.Dacpacs.Msdb). 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. [GitHub issue](https://github.com/microsoft/DacFx/issues/245)|
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. [GitHub issue](https://github.com/microsoft/DacFx/issues/258)|
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
+
|Deployment|Fixes an issue where external tables would be dropped and redeployed despite no changes when the table definition contained SQLCMD variables. [GitHub issue](https://github.com/microsoft/DacFx/issues/249)|
55
+
|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)|
56
+
|Import|Fixes an issue where an Azure Active Directory user cannot be created during import to Azure SQL Database, causing the import to fail. [GitHub issue](https://github.com/microsoft/DacFx/issues/260)|
57
+
|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.|
58
+
|Permissions|Fixes an issue where permissions assigned to a user in the database model are not recognized, causing the project build or SqlPackage operation to fail.|
59
+
|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.|
60
+
|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)|
61
+
|SQL Server 2022|Fixes an issue where the function `DATE_BUCKET` was not recognized as a built-in function.|
62
+
63
+
64
+
### Known Issues
65
+
| Feature | Details | Workaround |
66
+
| :------ | :------ |:------ |
67
+
| Deployment | The Azure Synapse Analytics Workload Management feature (Workload Groups and Workload Classifiers) isn't yet supported. | N/A |
68
+
| ScriptDOM | Parsing a very large file can result in a stack overflow. | None |
Copy file name to clipboardExpand all lines: docs/tools/sqlpackage/sqlpackage-download.md
+14-14Lines changed: 14 additions & 14 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -4,7 +4,7 @@ description: "Download and Install SqlPackage for Windows, macOS, or Linux"
4
4
author: "dzsquared"
5
5
ms.author: "drskwier"
6
6
ms.reviewer: "maghan"
7
-
ms.date: 2/13/2023
7
+
ms.date: 5/10/2023
8
8
ms.service: sql
9
9
ms.subservice: tools-other
10
10
ms.topic: conceptual
@@ -17,14 +17,14 @@ ms.custom:
17
17
18
18
SqlPackage runs on Windows, macOS, and Linux, and is available to install through `dotnet tool` or as a standalone zip download.
19
19
20
-
-**Version number:**161.8089.0
21
-
-**Build number:**16.1.8089.0
22
-
-**Release date:**February 13, 2023
20
+
-**Version number:**162.0.52.1
21
+
-**Build number:**162.0.52.1
22
+
-**Release date:**May 10, 2023
23
23
24
24
For details about the latest release, see the [release notes](release-notes-sqlpackage.md).
25
25
26
26
> [!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.52.1).
28
28
29
29
## Installation, cross-platform
30
30
@@ -58,10 +58,10 @@ To uninstall SqlPackage, run the following command:
@@ -168,7 +168,7 @@ Evergreen links are available for downloading the latest Sqlpackage versions:
168
168
169
169
## DacFx
170
170
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.52.1.
172
172
173
173
Adding the NuGet package to a .NET project is accomplished via the .NET CLI with this command:
174
174
@@ -215,16 +215,16 @@ SqlPackage runs on Windows, macOS, and Linux and is built using .NET 6. The [.N
215
215
This release of SqlPackage can be installed in the following languages:
|**/p:**|Storage=({File|Memory})|Specifies the type of backing storage for the schema model used during extraction. 'Memory' is default for .NET Core version of SqlPackage. 'File' is only available and default for .NET Framework version of SqlPackage.|
124
124
|**/p:**|TableData=(STRING)|Indicates the table from which data will be extracted. Specify the table name with or without the brackets surrounding the name parts in the following format: schema_name.table_identifier. This property may be specified multiple times to indicate multiple options.|
125
125
|**/p:**|TempDirectoryForTableData=(STRING)|Specifies the temporary directory used to buffer table data before being written to the package file.|
126
-
|**/p:**|VerifyExtraction=(BOOLEAN 'True')|Specifies whether the extracted schema model should be verified.|
126
+
|**/p:**|VerifyExtraction=(BOOLEAN 'False')|Specifies whether the extracted schema model should be verified.|
Copy file name to clipboardExpand all lines: docs/tools/sqlpackage/sqlpackage.md
+15-1Lines changed: 15 additions & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -4,7 +4,7 @@ description: Learn how to automate database development tasks with SqlPackage. V
4
4
author: "dzsquared"
5
5
ms.author: "drskwier"
6
6
ms.reviewer: "maghan"
7
-
ms.date: 6/1/2022
7
+
ms.date: 5/10/2023
8
8
ms.service: sql
9
9
ms.subservice: tools-other
10
10
ms.topic: conceptual
@@ -180,6 +180,20 @@ For Linux and macOS, if the path is not specified in the TMPDIR environment vari
180
180
[Contained database users](../../relational-databases/security/contained-database-users-making-your-database-portable.md) are included in SqlPackage operations. However, the password portion of the definition is set to a randomly generated string by SqlPackage, the existing value is not transferred. It is recommended that the new user's password is reset to a secure value following the import of a `.bacpac` or the deployment of a `.dacpac`. In an automated environment the password values can be retrieved from a secure keystore, such as Azure Key Vault, in a step following SqlPackage.
181
181
182
182
183
+
## Usage data collection
184
+
185
+
SqlPackage contains Internet-enabled features that can collect and send anonymous feature usage and diagnostic data to Microsoft.
186
+
187
+
SqlPackage may collect standard computer, use, and performance information that may be transmitted to Microsoft and analyzed to improve the quality, security, and reliability of SqlPackage.
188
+
189
+
SqlPackage doesn't collect user specific or personal information. To help approximate a single user for diagnostic purposes, SqlPackage will generate a random GUID for each computer it runs on and use that value for all events it sends.
190
+
191
+
For details, see the [Microsoft Privacy Statement](https://go.microsoft.com/fwlink/?LinkID=824704), and [SQL Server Privacy supplement](../../sql-server/sql-server-privacy.md).
192
+
193
+
### Disable telemetry reporting
194
+
195
+
To disable telemetry collection and reporting, update the environment variable `DACFX_TELEMETRY_OPTOUT` to `true` or `1`.
196
+
183
197
## Support
184
198
185
199
The DacFx library and the SqlPackage CLI tool have adopted the [Microsoft Modern Lifecycle Policy](https://support.microsoft.com/help/30881/modern-lifecycle-policy). All security updates, fixes, and new features will be released only in the latest point version of the major version. Maintaining your DacFx or SqlPackage installations to the current version helps ensure that you will receive all applicable bug fixes in a timely manner.
![prmerger-automator[bot]](https://avatars.githubusercontent.com/u/22479449?v=4&size=40){kind=avatar}
0 commit comments