Questions tagged [continuous-integration]
8 questions
5
votes
1 answer
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 for some assistance in improving the way we…
krystah
- 747
- 9
- 19
4
votes
1 answer
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 gives me this error:
This throws me off because the…
SQLStad
- 366
- 1
- 13
2
votes
1 answer
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 influenced by postgres but also by MS maybe-saying…
Chris F Carroll
- 214
- 2
- 10
1
vote
0 answers
How to improve Oracle Standard Edition's performance for testing?
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, there aren't any resources on doing the same for…
Rol
- 111
- 5
0
votes
0 answers
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 of minutes each time to start and shutdown. Is…
Rol
- 111
- 5
0
votes
1 answer
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 paid instance (with backups etc). I will likely…
Ash Oldershaw
- 121
- 4
0
votes
0 answers
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, sprocs, external data sources, external tables, etc)…
Wulung Triyanto
- 101
-1
votes
1 answer
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 close enough), that'd require creating the tables…
lfk
- 129
- 1
- 3