Stop editing code in Production database - a journey from 90's to CICD

Track

DevOps & Cloud

Date and time

Wednesday, 12. October 2022., 14:30

Room

Hall B

Duration

45'

Source control in databases is a difficult problem. There are tools like Liquibase or Flyway but none of those is fully addressing all challenges of applying changes to databases. This presentation is based on real life implementation and shows a story of a company moving from direct PL/SQL code edit on production server to CICD pipeline.List of the typical challenges covered in the presentation: - how to design a source control repository, - how to keep a DDL changes, - code merges, - continuous deployment without production outages - rollback - pipeline implementationsPresentation will finish with lesson learned and potential process and tools improvements including Oracle Cloud DevOps tools.

Lecture details

Talk Attendence: Attendance in person
Level of difficulty: General
Desirable listeners function: Developers , Team leader
Group of activity: DevOps & Cloud

About speaker