Questions tagged [continuous-integration]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
1answer
34 views

Automated testing of SQL scripts

I'd like to run some simple tests on SQL scripts in CI to just ensure the scripts are valid SQL (PostgreSQL). While I could run Postgres in Docker or even use an in-memory DB such as Sqlite (it's ...
3
votes
1answer
134 views

Missing master.dacpac publishing dacpac Azure Devops

The problem I have been trying to get a build pipeline to work in Azure DevOps to demo how we could build and test our databases. I've come to the point where I want to publish my DACPAC but it ...
0
votes
0answers
17 views

Add SQL Server Level Login in master Database using Visual Studio 2019

I'm trying to add sever login in Azure SQL Server using Visual Studio 2019 SQL Project with SSDT and deploy it using Azure Devops by building CICD pipeline. The rest database object (e.g. tables, ...
5
votes
1answer
403 views

How can we manage cross-database dependencies across environments?

I've put off asking this question for some time since it's tricky to encapsulate our situation and challenges without a wall of text, but the situation is getting worse so I'll do my best. I'm looking ...