Gain confidence in your database changes
summary
Shows how to export schema changes into Liquibase changelogs with SQLcl, commit them to Git, and run lb update so deployments are one consistent format across environments. Demonstrates idempotent change sets and the databasechangelog tables for deployment accountability, plus generating XML or SQL outputs. Also automates the flow with OCI DevOps and Terraform to spin up an Autonomous Database, run Liquibase, and verify success, arguing benefits: repeatability, traceable history, and safe CI/CD-friendly rollouts.
AI-written summary · about
chapters (13)
- 0:00Intro
- 2:05DevOps should enable both Speed and Reliability
- 3:01Guidelines for adopting a DevOps culture
- 5:41Key Liquibase Terminology
- 8:30Version Control Systems are essential tools
- 11:21Creating Schema Objects
- 15:17Adding Schema Objects to Version Control
- 17:40Repeatable Deployments
- 19:19Continuing Development
- 21:44Accountability & Reporting
- 22:35Automatic Deployment of Database Changes
- 24:18OCI DevOps Service: Build Pipeline
- 28:43Summary
related talks
22mLessons DevOps Can Teach Us About Managing Internet Scale Schemas
01h 00mLiquibase Data: Version Control and Collaboration for the Database
44mDatabase Change Management
23mHow to evolve your database applications entirely online
31mDevOps Practices for the Database Team
04mRoad to Percona Live 2022 - Robert Reeves
36mUnlocking the Benefits of Database DevOps and Automation
59mNavigating the Challenges of CI /CD for Relational Database Schema Changes
