👁 Image
Microsoft.SqlServer.Dacpacs.DbFabric 170.0.4

Microsoft.SqlServer.Dacpacs.DbFabric contains a .dacpac file for the system database objects in SQL database in Microsoft Fabric. Referencing this package in a SQL database project allows you to build and validate database projects with system object references that target SQL database in Microsoft Fabric.

📗 SQL projects database DevOps documentation

🧑‍💻 Get help and support

Usage

The reference to this package can be added to your SQL database project (.sqlproj) as follows:

...
 <ItemGroup>
 <PackageReference Include="Microsoft.SqlServer.Dacpacs.DbFabric" Version="170.0.4" />
 </ItemGroup>
</Project>

An example of a SQL database in Microsoft Fabric 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],
 [is_optimized_locking_on]
 FROM sys.databases
 WHERE name = @database_name;
END;

Related packages