This blog explains how to build the pipelines for SQL server project to publish the changes automatically to a target database.

You can refer here to create a SQL server project.

Once the project is created, push your changes to your code repoistory, here the code is in Azure Devops git repository.

Continuous Integration:

create new pipeline from Azure Devops pipelines menu and create a new pipeline.

Add below tasks and points to your sql server project solution, when this CI pipeline completes, it produces a DACPAC file as artifact after successful run.

Continuous Delivery:

Once CI pipeline is completed, you have DACPAC file as artifact which can deployed to an Azure SQL database using SQL Server database deploy task thru release pipeline.

Select Release pipeline option from pipelines menu and create a new release.

After selecting the artifacts, configure the stages, here as an example the stage is Dev.

Once the release is deployed successfully, you can see the changes in your target database.

This is how you can publish SQL server project changes to a target database using Azure Devops pipelines.