Microsoft.SqlServer.Dacpacs.FabricDw 170.0.4

Prefix Reserved

dotnet add package Microsoft.SqlServer.Dacpacs.FabricDw --version 170.0.4

NuGet\Install-Package Microsoft.SqlServer.Dacpacs.FabricDw -Version 170.0.4

This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.

<PackageReference Include="Microsoft.SqlServer.Dacpacs.FabricDw" Version="170.0.4" />

For projects that support PackageReference, copy this XML node into the project file to reference the package.

<PackageVersion Include="Microsoft.SqlServer.Dacpacs.FabricDw" Version="170.0.4" />
                    

                            Directory.Packages.props

<PackageReference Include="Microsoft.SqlServer.Dacpacs.FabricDw" />
                    

                            Project file

For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.

paket add Microsoft.SqlServer.Dacpacs.FabricDw --version 170.0.4

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

#r "nuget: Microsoft.SqlServer.Dacpacs.FabricDw, 170.0.4"

#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.

#:package Microsoft.SqlServer.Dacpacs.FabricDw@170.0.4

#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.

#addin nuget:?package=Microsoft.SqlServer.Dacpacs.FabricDw&version=170.0.4
                    

                            Install as a Cake Addin

#tool nuget:?package=Microsoft.SqlServer.Dacpacs.FabricDw&version=170.0.4
                    

                            Install as a Cake Tool

The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Microsoft.SqlServer.Dacpacs.FabricDw contains a .dacpac file for the Data warehouse in Fabric system objects. Referencing this package in a SQL database project allows you to build and validate database projects with system object references that target Data warehouse in 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.FabricDw" Version="$PACKAGE_VERSION$" />
  </ItemGroup>
</Project>

An example of Data warehouse in Fabric system objects referenced in a SQL database project is shown below:

CREATE VIEW dbo.vw_SystemTables
AS
SELECT
    s.name  AS schema_name,
    t.name  AS table_name,
    t.object_id,
    t.create_date,
    t.modify_date
FROM sys.tables t
JOIN sys.schemas s
    ON t.schema_id = s.schema_id;

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.Master	SQL Server	Microsoft.SqlServer.Dacpacs.Master is a set of NuGet packages containing .dacpac files for Microsoft SQL Server master databases.
Microsoft.SqlServer.Dacpacs.Msdb	SQL Server	Microsoft.SqlServer.Dacpacs.Msdb is a set of NuGet packages containing .dacpac files for Microsoft SQL Server msdb databases.
Microsoft.SqlServer.Dacpacs.Synapse.Master	Azure Synapse Analytics	Microsoft.SqlServer.Dacpacs.Synapse.Master is a NuGet package containing a .dacpac file for the Azure Synapse Analytics master database.
Microsoft.SqlServer.Dacpacs.SynapseServerless.Master	Azure Synapse Analytics serverless pools	Microsoft.SqlServer.Dacpacs.SynapseServerless.Master is a NuGet package containing a .dacpac file for the Azure Synapse Analytics serverless SQL pools master database.