Flyway migrations on Azure pipelines (CI/CD)

Demo 02

Version 1.0

Repository structure
Kubernetes architecture
Connect and show SQL Server GeoKids empty shell database
Review Flyway migration image
Review Flyway migrations - SQL files (v1.0)
Review Dockerfiles
Review Kubernetes manifests
Review Azure pipeline
Push changes to repository
Monitor Azure pipeline
Check Flyway migration job status
Review Flyway schema history
Review changes in SQL Server GeoKids database
Check GeoKids website
Create Kubernetes and GitHub release tag
Check pipeline CI options

Demo 03

Version 2.0

Review repository structure
Check webapp rollout history - Kubernetes deployment
Create version 2.0 branch (local repository)
Exchange webapp versions
Add new migrations to SQL scripts folder
Review Flyway new migrations structure'
Review Flyway migrations - SQL files
Change pipeline CI options
Push changes to repository (v2.0)
Create pull request (master <- v2.0)
Monitor Azure pipeline
Check Flyway migration job status
Review Flyway schema history
Review changes in SQL Server GeoKids database
Check GeoKids website - New frontend (v2.0)
Repository cleanup and release tag

Questions?

If you have questions or comments about this demo, don't hesitate to contact me at [email protected]

Follow me