bcgov / nr_fsa_fingerprint

This repo is not for a specific project, but as a holder for the Forest Service Applications work by FSA team 2 (fingerprint)
Apache License 2.0
1 stars 0 forks source link

Create DB script process for DBAs #30

Closed ConradBoydElliottGustafson closed 2 years ago

ConradBoydElliottGustafson commented 2 years ago

In order to request activity from a DBA, they need to have a database script that they can run (and re-run if necessary). This is usually provided to them in the form of a zip file. We created a new GitHub repo to store the scripts that we want them to run: https://github.com/bcgov/nr-fsa-scripts

DBAs need to be able to download a single zip file to run their scripts. Even though it is a manual process that could possibly invalidate the version control of these scripts, we decided that a simple solution was to check in a zip file with the scripts along with the scripts themselves. We can then give them a link to the zip file in GitHub. Since it is a public repo, they don't need to have a GitHub account or use any git commands locally.

In order to help them understand and feel confident that the link we give them cannot change, we need to document this process.

AC: Readme.md on the nr-fsa-scripts repository that explains to the DBAs the process that we use for developing scripts and zipping them up for consumption via https download.

Make sure that you capture the fact that you need to create a JIRA ticket. The way that change management works is that each project needs its own JIRA project. Any request to an infrastructure team has to have a JIRA ticket.

image.png