Building On Premise Databases in an Azure Hosted Build Agent

We're moving from on-premises Azure DevOps to cloud hosted Azure DevOps using cloud build agents and we've run into a couple of related issues.

1. The build agent doesn't have access to our internal network so it can't validate users/groups etc. This gives us errors like:-

##[warning]	DbBuildTask: ERROR D:\a\1\s\<redacted>\Migrations\001_20200416-1026_<redacted>.sql(0,0): Windows NT user or group '<redacted>' not found. Check the name again.

2. The second issue we're running into is how to handle cross database dependencies, we have a handful of databases that refer to objects in a third party developed database.

What are our options for working around these complexities?

David Hayes September 21, 2023 21:48

Comments

1 comment

Hi @...

For the first point, the best practise would be to filter out users using filters then assign permissions to roles instead

Part two, the simplest method would be to make use of synonyms :https://www.red-gate.com/hub/product-learning/sql-change-automation/database-build-blockers-cross-server-database-dependencies

DanC September 27, 2023 11:26

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Building On Premise Databases in an Azure Hosted Build Agent

Comments

Add comment