Questions tagged [continuous-integration]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
2
votes
1answer
59 views

Minimal Permissions to Create an Application Database and Database Owner

I wish to write (or borrow if you have one) a script template for creating an application database and associated logins. The script is to be run in CI pipelines and on developer desktops. Possibly ...
0
votes
0answers
34 views

How can I start Oracle as a lightweight process?

I have OracleDB running in a CI pipeline in a docker image. With each test it is started and then shutdown. It's purely there because Django tests expect a real database. However it takes a couple ...
1
vote
0answers
53 views

How to improve Oracle Standard Edition's performance for testing? [closed]

There's a great post on StackOverflow about improving Postgres performance for testing. https://stackoverflow.com/questions/9407442/optimise-postgresql-for-fast-testing/9407940#9407940 However, ...
0
votes
1answer
55 views

Deploying Oracle ADW Changes from development environment to production

I'm currently running an Oracle Autonomous Data Warehouse (Oracle's cloud-based database offering) on version 19c. I have a development database on the Always Free Tier and my production database is a ...
-1
votes
1answer
123 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
426 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
69 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
737 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 ...