We have a SQL Server Data Tools (SSDT) Visual Studio database project, and we deploy the DACPAC output using DacFx + PowerShell scripts. In this project, we enable: Database-level change tracking via ...

I have a .sqlproj with some CDC enabled tables. My ADO CD pipeline does a sqlpackage Action:script and then sqlpackage Action:publish. I had a requirement to add some columns to one of the CDC enabled ...

One of my clients has an on-premises SQL Server 2022 database. I'm building a deployment pipeline in Azure DevOps that builds a DACPAC file based on a VS2022 project and deploys this to the server. We ...

I would like to reference a sqlproj project in one of my other projects to get a current dacpac file so I can publish a database. I need this both while running unit tests but also to debug my ...

The whole plan is to create dacpacs in linux docker container. I saw that there is dotnet msbuild option, however when I try to build the project it complains that it can't find Microsoft.Data.Tools....

The question is very simple: I have a database which uses some schemas dbo, custom1, custom2. Now dbo and custom1 are present in the database project, won't have any problem with those. But custom2 ...

I need to generate the database and all related objects related scripts based on existing dacpac. However ideally I would like to do so without running actual database instance. Is it possible to do ...

I am experiencing an unresolved reference error when I try to build my project because my project contains views that reference another database on the same server. When I try to add a database ...

I am currently trying to extract the column datatype from the SQL Server tables, views & functions in C# using DacFx in .NET. I would like to retrieve the same information with DacFx that I can ...

I've been trying to create a SQL Server container and then a container to install a database from a .sqlproj and for that I'm using a dockerfile. The trouble is that when I run the command docker ...

I am writing a Powershell script to create a SQL Server dacpac file from our QA database and publish it to the local db. I am using SQLPackage.exe. When I publish, I am getting an error: Could not ...

I have sql DB project created in VS 2022, In there I have a Stored procedure and I Parameterized the Server and db as it connects to different server using link server. I create a build in Azure ...

We have an existing database and a DACPAC-based deployment procedure to send it schema updates at deploy time. The database has an existing partition function and existing partition schemes, and the ...

I have written a tool to update multiple databases as part of our DEVOPS CI/CD pipeline. This tool works without issue. We are migrating host platforms for our SaaS product, and as part of this, I ...

We are updating schema by running ALTER SCHEMA command for existing tables and other objects in Microsoft SQL Server 2017 (RTM-CU22) (KB4577467). As a part of steps we are first creating the ...