HydrologicEngineeringCenter / HydrologicEngineeringCenter/cwms-database
Create Schema Update container
@MikeNeilson is already working on this.
Since Sep 17, 2026.
- Dominant language
- Visual Basic 6.0
- Stars
- 4
- Forks
- 8
- Avg merge
- 8d 20h
- Merged PRs (30d)
- 4
Description
At this time CDA self hosts a "migration" image that doesn't really behave all that well. Additionally we don't have a good way to automate schema updates.
Until such time as flyway is used (the flyway schema image would just be the schema update/migration container) it makes sense to generate a specific migration container for the database.
Primarily for Testing database upgrades (we can take previous the version(s) and apply this batches current updates) it also allows CDA to target upgrading to a specific database version in an automated way instead of the rather off forced 99.99.99 system we're currently using. (The CDA migration container only handles the fresh install, the migration attempts never behaved well.)
Contributor guide
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.