Microsoft/Microsoft.SqlServer.Dacpacs.Masterv170.0.3
✓ Verified.NET FW4.7.2.NET 8.0.NET 10.0.NET Std2.0
This package contains the master.dacpac for SQL Server 170.
Get Started
$ dotnet add package Microsoft.SqlServer.Dacpacs.MasterReadme
Microsoft.SqlServer.Dacpacs.Master contains a .dacpac file for the SQL Server system objects. Referencing this package in a SQL database project allows you to build and validate database projects with system object references that target SQL Server.
📗 SQL projects database DevOps documentation
Usage
The reference to this package can be added to your SQL database project (.sqlproj) as follows:
...
<ItemGroup>
<PackageReference Include="Microsoft.SqlServer.Dacpacs.Master" Version="170.0.3" />
</ItemGroup>
</Project>
An example of a SQL Server system object referenced in a SQL database project is shown below:
CREATE PROCEDURE dbo.usp_GetDatabaseProperties
@database_name SYSNAME
AS
BEGIN
SET NOCOUNT ON;
SELECT
[database_id],
[name],
[create_date],
[collation_name],
[containment],
[is_change_feed_enabled], -- 160 and above
[is_optimized_locking_on] -- 170 and above
FROM sys.databases
WHERE name = @database_name;
END;
Related packages
| Package | Target platforms | Description |
|---|---|---|
| Microsoft.SqlServer.Dacpacs.Azure.Master | Azure SQL Database | Microsoft.SqlServer.Dacpacs.Azure.Master is a NuGet package containing a .dacpac file for the Azure SQL Database master database. |
| Microsoft.SqlServer.Dacpacs.DbFabric | SQL database in Fabric | Microsoft.SqlServer.Dacpacs.DbFabric is a NuGet package containing a .dacpac file for the SQL database in Fabric system objects. |
| Microsoft.SqlServer.Dacpacs.FabricDw | Data warehouse in Fabric | Microsoft.SqlServer.Dacpacs.FabricDw is a NuGet package containing a .dacpac file for the Data warehouse in Fabric system objects. |