Build and Deploy Database Projects with Azure DevOps

Watch this video to find out how you can automatically build and deploy your Database Projects with Azure DevOps. You can either use SQL Server Data Tools with Visual Studio or Database Projects with Azure Data Studio.

Either way, you'll be able to easily and quickly deploy your database projects.

[rachwalskimarcin]

Love this idea! Azure Devops with Azure Data Studio🥳 Looking what has changed for this 2 years!

[jonathancharlesbass]

Nice video. Well-paced and very infromative. I am going to try this into Azure tomorrow 👍

[BrianOchs]

Good job on this tutorial. Followed your steps and it worked like a charm!

[MarkMorganLancaster]

Great, straightforward explanation. Really helpful, thank you.

[quillis]

@Elizabeth Noble : I get build errors, apparently it is failing on scripts referencing system objects while piping through devops (tried msbuild and visual studio task). I referenced Master db (package) while using ADS and I could see an entry in .sqlproj file, ADS builds and publishes great. Any troubleshooting tips will be greatly appreciated.

[NurseDaveBSMSON]

That was great. I hope you keep making these.

[rajasekharreddy]

How to execute mutiple sql in Azure devops to execute in Azure Database

[alikettani]

Thanks for the great video. Quick Question : Since you are deploying to an On-prem sql server, do you need to install a self-hosted Agent in your Server, or you can use an azure pipelines Agent?

[sean]

great tutorial! I had question, where did you copy your Source and Target folder names from when creating the Copy File task in the pipeline?

[samsams]

thank you, do you have the process to deploy the database in azure sql server, thank you again

[harikrishnak]

I am getting following two errors as I have linked servers on my database. Can you please help me configure them in my db project dacpac?
SQL71561: View:'View' contains an unresolved reference to an object. Either the object does not exist or the reference is ambiguous because it could refer to any of the following objects: blah blah and State
Warning SQL71502: Procedure: 'Table' has an unresolved reference to object [sys].[objects].[type].

[agasti]

Hi Elizabeth,

I had 2 questions and would really appreciate your inputs.

1. In the build pipeline, what's the significance of copying the dacpac on to artifact staging directory and why we need to do that?

2. In our database (AZ SQL database), there are a few tables whose DDL change dynamically as a part of ETL? As a result, I am unable to bring the DB under GIT as it modifies schema of those tables in the release. I can't separate these tables from the DB as they are used heavily in other procs and views as these are basically contain source data. I could not find any way to make the project "ignore" the schematic differences on these tables (isolated in a separate schema).

[rajasekharreddy]

How to execute mutiple sql in Azure devops to execute in Azure Database