search

microsoft / DacFx

DacFx, SqlPackage, and other SQL development libraries enable declarative database development and database portability across SQL versions and environments. Share feedback here on dacpacs, bacpacs, and SQL projects.
https://aka.ms/sqlpackage-ref
MIT License
307 stars 18 forks source link

Unclarity on system .dacpacs #466

Closed ErikEJ closed 1 day ago

ErikEJ commented 1 month ago

There are a number of non deprecated package versions published for each engine edition here: https://www.nuget.org/packages/Microsoft.SqlServer.Dacpacs.Master#versions-body-tab

Is the advise to always use the latest version? If so, maybe consider deprecating the older versions so consumers become aware of the updates?

dzsquared commented 1 month ago

Non-formalized advice is to use the latest version that aligns with the version of SQL, there are 7 versions of SQL associated with the system dacpacs

image

Tagging this to documentation for my backlog so this gets better captured, will likely deprecate the handful of "aged out" versions.

dzsquared commented 1 month ago

fyi @zijchen

ErikEJ commented 1 month ago

Thanks, I will add this to the MsBuild.SDK.SqlProj docs as a user had issues with an older package version (master 150.0.0)

dzsquared commented 1 day ago

included here - https://learn.microsoft.com/en-us/sql/tools/sql-database-projects/concepts/package-references?view=sql-server-ver16&pivots=sq1-visual-studio#system-databases