smagara / smagara/AgilitySports_data
Subitem: create a GitHub Action CI/CD pipeline for QA SQL
@smagara is already working on this.
Since Nov 2, 2025.
- Dominant language
- TSQL
- Stars
- 0
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
Task Description
Create a GitHub Action CI/CD pipeline for approved PR requests to the QA environment, similar to what exists for the production environment. On successful PR approval to the QA git branch, say "qa_main", GitHub should execute the associated TSQL files on the Azure SQL QA database.
At first, changes can be YOLO'ed directly into QA but as the environment takes shape, increasingly the pipeline should run the scripts automatically, so that ultimately a smooth process takes shape to support testing of database changes before production.
Acceptance Criteria
- Criteria 1
- Criteria 2
- Criteria 3
Technical Details
Same as production: any order-dependencies are to be handled by the order of PR approvals, as granular as is needed, and documented for approvers in the PRs.
Additional Context
Related Issues
Parent #15
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.