Skip to content

Commit 82adef5

Browse files
dzsquareddzsquared
committed
adding rel notes
1 parent 95d6ea9 commit 82adef5

2 files changed

Lines changed: 146 additions & 108 deletions

File tree

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

Lines changed: 132 additions & 94 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
title: DacFx and SqlPackage release notes
33
description: Release notes for Microsoft SqlPackage.
44
ms.custom: "tools|sos"
5-
ms.date: 11/9/2022
5+
ms.date: 2/13/2023
66
ms.service: sql
77
ms.reviewer: "llali"
88
ms.topic: conceptual
@@ -15,14 +15,58 @@ ms.author: drskwier
1515

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

18+
## 161.8089.0 SqlPackage
19+
20+
**Release date:** February 13, 2023
21+
22+
|Platform|Download|Version|Build
23+
|:---|:---|:---|:---|
24+
|Windows .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2224909)|161.8089.0|16.1.8089.0|
25+
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2224908)|161.8089.0|16.1.8089.0|
26+
|macOS .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2225106)|161.8089.0|16.1.8089.0|
27+
|Linux .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2225105)|161.8089.0|16.1.8089.0|
28+
29+
> [!IMPORTANT]
30+
> Version 161 of SqlPackage encrypts database connections by default. Previously successful connections with self-signed certificates or without encryption may not connect with v161 without updating the SqlPackage parameters. For more information, see [https://aka.ms/dacfx-connection](https://aka.ms/dacfx-connection).
31+
32+
33+
### Features
34+
| Feature | Details |
35+
| :------ | :------ |
36+
|Deployment|Adds the ability for the `GenerateSmartDefaults` property on publish to populate values from a default constraint when set to `true`. [GitHub issue](https://github.com/microsoft/DacFx/issues/38)|
37+
|Serverless pools|Adds support for serverless SQL pools in Extract and Publish operations.|
38+
|SQL Server 2022|Adds support for [ordered clustered columnstore indexes](../../relational-databases/indexes/columnstore-indexes-design-guidance.md#use-an-ordered-clustered-columnstore-index-for-large-data-warehouse-tables).|
39+
40+
41+
### Fixes
42+
| Feature | Details |
43+
| :------ | :------ |
44+
|Deployment|Fixes an issue where publish to SQL on Linux would fail due to the default data and log paths being empty. [GitHub issue](https://github.com/microsoft/DacFx/issues/136)|
45+
|Deployment|Fixes an issue where publishing an external table with file format changes would result in an error. [GitHub issue](https://github.com/microsoft/DacFx/issues/120)|
46+
|Deployment|Fixes an issue where publish with a column encrypted with randomized encryption would not fail immediately if the column encryption key (CEK) was inaccessible, delaying the deployment error until the column encryption step.|
47+
|Refactor|Fixes an issue where a renamed column on a system versioned table would result in the system versioning being turned off and not turned back on. [GitHub issue](https://github.com/microsoft/DacFx/issues/203)|
48+
|Platform|Fixes an issue where SqlPackage operations would fail on RHEL 9 due to an encryption error. Moves to use the 6.0.10 version of the .NET 6 runtime. [GitHub issue](https://github.com/microsoft/DacFx/issues/168)|
49+
|Schema compare|Fixes an issue where the `DoNotEvaluateSqlCmdVariables` property for *Publish* and *Script* would result in the SqlCmd variables also not being evaluated on both the source and target instead of only the source.|
50+
|ScriptDOM|Fixes external table support for `REJECT_SAMPLE_VALUE`.|
51+
|ScriptDOM|Fixes an issue where compression options could not be applied to a table with a clustered index.|
52+
|SQL projects|Fixes an issue where valid options for the `QueryStoreFlushInterval` are incorrectly reported as invalid. [Developer Community report](https://developercommunity.visualstudio.com/t/SQL72003:-The-value-300-for-property-Que/10210937)|
53+
54+
### Known Issues
55+
| Feature | Details | Workaround |
56+
| :------ | :------ |:------ |
57+
| Deployment | The Azure Synapse Analytics Workload Management feature (Workload Groups and Workload Classifiers) isn't yet supported. | N/A |
58+
| ScriptDOM | Parsing a very large file can result in a stack overflow. | None |
59+
1860
## 161.6374.0 SqlPackage
1961

20-
|Platform|Download|Release date|Version|Build
21-
|:---|:---|:---|:---|:---|
22-
|Windows .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2215400)|November 9, 2022|161.6374.0|16.1.6374.0|
23-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2215326)|November 9, 2022|161.6374.0|16.1.6374.0|
24-
|macOS .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2215401)|November 9, 2022|161.6374.0|16.1.6374.0|
25-
|Linux .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2215501)|November 9, 2022|161.6374.0|16.1.6374.0|
62+
**Release date:** November 9, 2022
63+
64+
|Platform|Download|Version|Build
65+
|:---|:---|:---|:---|
66+
|Windows .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2215400)|161.6374.0|16.1.6374.0|
67+
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2215326)|161.6374.0|16.1.6374.0|
68+
|macOS .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2215401)|161.6374.0|16.1.6374.0|
69+
|Linux .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2215501)|161.6374.0|16.1.6374.0|
2670

2771
> [!IMPORTANT]
2872
> Version 161 of SqlPackage encrypts database connections by default. Previously successful connections with self-signed certificates or without encryption may not connect with v161 without updating the SqlPackage parameters. For more information, see [https://aka.ms/dacfx-connection](https://aka.ms/dacfx-connection).
@@ -54,12 +98,14 @@ This article lists the features and fixes delivered by the released versions of
5498

5599
## 19.2 SqlPackage
56100

57-
|Platform|Download|Release date|Version|Build
58-
|:---|:---|:---|:---|:---|
59-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2209512)|September 22, 2022|19.2|16.0.6296.0|
60-
|macOS .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2209610)|September 22, 2022| 19.2|16.0.6296.0|
61-
|Linux .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2209513)|September 22, 2022| 19.2|16.0.6296.0|
62-
|Windows .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2209609)|September 22, 2022| 19.2|16.0.6296.0|
101+
**Release date:** September 22, 2022
102+
103+
|Platform|Download|Version|Build
104+
|:---|:---|:---|:---|
105+
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2209512)|19.2|16.0.6296.0|
106+
|macOS .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2209610)| 19.2|16.0.6296.0|
107+
|Linux .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2209513)| 19.2|16.0.6296.0|
108+
|Windows .NET 6 |[.zip file](https://go.microsoft.com/fwlink/?linkid=2209609)| 19.2|16.0.6296.0|
63109

64110

65111
### Features
@@ -91,12 +137,14 @@ This article lists the features and fixes delivered by the released versions of
91137

92138
## 19.1 SqlPackage
93139

94-
|Platform|Download|Release date|Version|Build
95-
|:---|:---|:---|:---|:---|
96-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2196438)|May 24, 2022|19.1|16.0.6161.0|
97-
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2196439)|May 24, 2022| 19.1|16.0.6161.0|
98-
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2196335)|May 24, 2022| 19.1|16.0.6161.0|
99-
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2196334)|May 24, 2022| 19.1|16.0.6161.0|
140+
**Release date:** May 24, 2022
141+
142+
|Platform|Download|Version|Build
143+
|:---|:---|:---|:---|
144+
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2196438)|19.1|16.0.6161.0|
145+
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2196439)| 19.1|16.0.6161.0|
146+
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2196335)| 19.1|16.0.6161.0|
147+
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2196334)| 19.1|16.0.6161.0|
100148

101149

102150
### Features
@@ -133,12 +181,14 @@ This article lists the features and fixes delivered by the released versions of
133181

134182
## 19.0 SqlPackage
135183

136-
|Platform|Download|Release date|Version|Build
137-
|:---|:---|:---|:---|:---|
138-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2185764)|January 25, 2022|19.0|16.0.5400.1|
139-
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2185765)|January 25, 2022| 19.0|16.0.5400.1|
140-
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2185670)|January 25, 2022| 19.0|16.0.5400.1|
141-
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2185669)|January 25, 2022| 19.0|16.0.5400.1|
184+
**Release date:** January 25, 2022
185+
186+
|Platform|Download|Version|Build
187+
|:---|:---|:---|:---|
188+
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2185764)|19.0|16.0.5400.1|
189+
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2185765)| 19.0|16.0.5400.1|
190+
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2185670)| 19.0|16.0.5400.1|
191+
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2185669)| 19.0|16.0.5400.1|
142192

143193

144194
### Features
@@ -177,12 +227,14 @@ This article lists the features and fixes delivered by the released versions of
177227

178228
## 18.8 SqlPackage
179229

180-
|Platform|Download|Release date|Version|Build
181-
|:---|:---|:---|:---|:---|
182-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2164920)|October 4, 2021|18.8|15.0.5282.3|
183-
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2165009)|October 4, 2021| 18.8|15.0.5282.3|
184-
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2165008)|October 4, 2021| 18.8|15.0.5282.3|
185-
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2165007)|October 4, 2021| 18.8|15.0.5282.3|
230+
**Release date:** October 4, 2021
231+
232+
|Platform|Download|Version|Build
233+
|:---|:---|:---|:---|
234+
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2164920)|18.8|15.0.5282.3|
235+
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2165009)| 18.8|15.0.5282.3|
236+
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2165008)| 18.8|15.0.5282.3|
237+
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2165007)| 18.8|15.0.5282.3|
186238

187239

188240
### Features
@@ -228,12 +280,9 @@ This article lists the features and fixes delivered by the released versions of
228280

229281
## 18.7.1 SqlPackage
230282

231-
|Platform|Download|Release date|Version|Build
232-
|:---|:---|:---|:---|:---|
233-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2165211)|June 2, 2021|18.7.1|15.0.5164.1|
234-
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2165132)|June 2, 2021| 18.7.1|15.0.5164.1|
235-
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2165213)|June 2, 2021| 18.7.1|15.0.5164.1|
236-
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2165212)|June 2, 2021| 18.7.1|15.0.5164.1|
283+
**Release date:** June 2, 2021
284+
285+
**Build:** 15.0.5164.1
237286

238287
### Features
239288
| Feature | Details |
@@ -250,12 +299,9 @@ This article lists the features and fixes delivered by the released versions of
250299

251300
## 18.7 SqlPackage
252301

253-
|Platform|Download|Release date|Version|Build
254-
|:---|:---|:---|:---|:---|
255-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2157201)|March 10, 2021|18.7|15.0.5084.2|
256-
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2157203)|March 10, 2021| 18.7|15.0.5084.2|
257-
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2157202)|March 10, 2021| 18.7|15.0.5084.2|
258-
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2157302)|March 10, 2021| 18.7|15.0.5084.2|
302+
**Release date:** March 10, 2021
303+
304+
**Build:** 15.0.5084.2
259305

260306
### Features
261307
| Feature | Details |
@@ -298,12 +344,9 @@ This article lists the features and fixes delivered by the released versions of
298344

299345
## 18.6 SqlPackage
300346

301-
|Platform|Download|Release date|Version|Build
302-
|:---|:---|:---|:---|:---|
303-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2143544)|September 18, 2020|18.6|15.0.4897.1|
304-
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2143659)|September 18, 2020| 18.6|15.0.4897.1|
305-
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2143497)|September 18, 2020| 18.6|15.0.4897.1|
306-
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2143496)|September 18, 2020| 18.6|15.0.4897.1|
347+
**Release date:** September 18, 2020
348+
349+
**Build:** 15.0.4897.1
307350

308351
### Features
309352
| Feature | Details |
@@ -333,12 +376,10 @@ This article lists the features and fixes delivered by the released versions of
333376

334377
## 18.5.1 SqlPackage
335378

336-
|Platform|Download|Release date|Version|Build
337-
|:---|:---|:---|:---|:---|
338-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2134206)|June 24, 2020|18.5.1|15.0.4826.1|
339-
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2134312)|June 24, 2020| 18.5.1|15.0.4826.1|
340-
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2134311)|June 24, 2020| 18.5.1|15.0.4826.1|
341-
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2134310)|June 24, 2020| 18.5.1|15.0.4826.1|
379+
**Release date:** June 24, 2020
380+
381+
**Build:** 15.0.4826.1
382+
342383

343384
### Fixes
344385
| Feature | Details |
@@ -347,12 +388,10 @@ This article lists the features and fixes delivered by the released versions of
347388

348389
## 18.5 SqlPackage
349390

350-
|Platform|Download|Release date|Version|Build
351-
|:---|:---|:---|:---|:---|
352-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2128142)|April 28, 2020|18.5|15.0.4769.1|
353-
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2128145)|April 28, 2020| 18.5|15.0.4769.1|
354-
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2128144)|April 28, 2020| 18.5|15.0.4769.1|
355-
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2128143)|April 28, 2020| 18.5|15.0.4769.1|
391+
**Release date:** April 28, 2020
392+
393+
**Build:** 15.0.4769.1
394+
356395

357396
### Features
358397
| Feature | Details |
@@ -389,12 +428,10 @@ This article lists the features and fixes delivered by the released versions of
389428

390429
## 18.4.1 SqlPackage
391430

392-
|Platform|Download|Release date|Version|Build
393-
|:---|:---|:---|:---|:---|
394-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2113703)|December 13, 2019|18.4.1|15.0.4630.1|
395-
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2113705)|December 13, 2019| 18.4.1|15.0.4630.1|
396-
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2113331)|December 13, 2019| 18.4.1|15.0.4630.1|
397-
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2113704)|December 13, 2019| 18.4.1|15.0.4630.1|
431+
**Release date:** December 13, 2019
432+
433+
**Build:** 15.0.4630.1
434+
398435

399436
### Fixes
400437
| Fix | Details |
@@ -409,12 +446,10 @@ This article lists the features and fixes delivered by the released versions of
409446

410447
## 18.4 SqlPackage
411448

412-
|Platform|Download|Release date|Version|Build
413-
|:---|:---|:---|:---|:---|
414-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2108813)|October 29, 2019|18.4|15.0.4573.2|
415-
|macOS .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2108815)|October 29, 2019| 18.4|15.0.4573.2|
416-
|Linux .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2108814)|October 29, 2019| 18.4|15.0.4573.2|
417-
|Windows .NET Core |[.zip file](https://go.microsoft.com/fwlink/?linkid=2109019)|October 29, 2019| 18.4|15.0.4573.2|
449+
**Release date:** October 29, 2019
450+
451+
**Build:** 15.0.4573.2
452+
418453

419454
### Features
420455

@@ -445,12 +480,10 @@ This article lists the features and fixes delivered by the released versions of
445480

446481
## 18.3.1 SqlPackage
447482

448-
|Platform|Download|Release date|Version|Build
449-
|:---|:---|:---|:---|:---|
450-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2102893)|September 13, 2019|18.3.1|15.0.4538.1|
451-
|macOS .NET Core (preview)|[.zip file](https://go.microsoft.com/fwlink/?linkid=2102894)|September 13, 2019| 18.3.1|15.0.4538.1|
452-
|Linux .NET Core (preview)|[.zip file](https://go.microsoft.com/fwlink/?linkid=2102978)|September 13, 2019| 18.3.1|15.0.4538.1|
453-
|Windows .NET Core (preview)|[.zip file](https://go.microsoft.com/fwlink/?linkid=2102979)|September 13, 2019| 18.13.1|15.0.4538.1|
483+
**Release date:** September 13, 2019
484+
485+
**Build:** 15.0.4538.1
486+
454487

455488
### Features
456489

@@ -479,11 +512,10 @@ This article lists the features and fixes delivered by the released versions of
479512

480513
## 18.2 SqlPackage
481514

482-
|Platform|Download|Release date|Version|Build
483-
|:---|:---|:---|:---|:---|
484-
|Windows|[MSI Installer](https://go.microsoft.com/fwlink/?linkid=2087429)|April 15, 2019|18.2|15.0.4384.2|
485-
|macOS .NET Core (preview)|[.zip file](https://go.microsoft.com/fwlink/?linkid=2087247)|April 15, 2019 | 18.2 |15.0.4384.2|
486-
|Linux .NET Core (preview)|[.zip file](https://go.microsoft.com/fwlink/?linkid=2087431)|April 15, 2019 | 18.2 |15.0.4384.2|
515+
**Release date:** April 15, 2019
516+
517+
**Build:** 15.0.4384.2
518+
487519

488520
### Features
489521

@@ -504,8 +536,10 @@ This article lists the features and fixes delivered by the released versions of
504536

505537
## 18.1 SqlPackage
506538

507-
Release date:   February 1, 2019
508-
Build:   15.0.4316.1
539+
**Release date:** February 1, 2019
540+
541+
**Build:** 15.0.4316.1
542+
509543
Preview release.
510544

511545
### Features
@@ -539,8 +573,9 @@ This release includes cross-platform preview builds of SqlPackage that target .N
539573

540574
## 18.0 SqlPackage
541575

542-
Release date:   October 24, 2018
543-
Build:   15.0.4200.1
576+
**Release date:** October 24, 2018
577+
578+
**Build:** 15.0.4200.1
544579

545580
### Features
546581

@@ -564,8 +599,9 @@ Build:   15.0.4200.1
564599

565600
## 17.8 SqlPackage
566601

567-
Release date:   June 22, 2018
568-
Build:   14.0.4079.2
602+
**Release date:** June 22, 2018
603+
604+
**Build:** 14.0.4079.2
569605

570606
### Features
571607

@@ -583,8 +619,9 @@ Build:   14.0.4079.2
583619

584620
## 17.4.1 SqlPackage
585621

586-
Release date:   January 25, 2018
587-
Build:   14.0.3917.1
622+
**Release date:** January 25, 2018
623+
624+
**Build:** 14.0.3917.1
588625

589626
### Features
590627

@@ -603,8 +640,9 @@ Build:   14.0.3917.1
603640

604641
## 17.4.0 SqlPackage
605642

606-
Release date:   December 12, 2017
607-
Build:   14.0.3881.1
643+
**Release date:** December 12, 2017
644+
645+
**Build:** 14.0.3881.1
608646

609647
### Features
610648

0 commit comments

Comments
 (0)