smagara / smagara/AgilitySports_data
Subitem: create the QA SQL database on Azure
- Dominant language
- TSQL
- Stars
- 0
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
Task Description
Create a QA database on the Azure SQL instance for the new development, migration, and future SDLC testing.
Acceptance Criteria
- For cost-savings, utilize the same SQL instance
- Regression test the production website after installation.
- Update the API to support an
Azure_QAconnection string. - Local dev testing with Docker is not affected, as the Docker is not used in production.
Technical Details
The original (V1) schema was created as a fully-fledged MS SQL database on Azure, and V2 was added as Serverless. The Serverless database is slower to power up, resulting in a grid refresh error on the first try. This is fine for QA, which should be rarely used. These databases were therefore renamed and swapped, using the V2 SQL seed scripts.
Additional Context
Regression testing confirms instant grid refreshes from the jump.
Related Issues
Parent Item: #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.