Skip to Main Content

Explore Oracle PL/SQL

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

October 15

15:00 UTC   Start Times Around the World

Description

Continuous Database Migrations with PL/SQL
Database migrations need to happen frequently to apply changes in database applications. Those migrations can be small, like adding new objects or changing some procedures or functions. Migrations can also be more extensive, like migrating large tables. In both cases, the database migrations need to be robust and repeatable if something goes wrong. In this PL/SQL Office Hours, we will explore practices to ensure high quality in your PL/SQL database migrations. We will have a look which elements make your database migrations repeatable and give an introduction on how to get started with automated database migrations if you have never done any before.

Highlights

00:00 Introduction from Steven
02:10 Overview of database migrations
06:24 challenges with deployments
10:18 Team performance and delivery
12:37 Characteristics of good migrations
17:49 Maximizing automation of deployments
21:50 Q&A deployment vs migration, release every day?, ebr
25:03 Code for repeatable and non-repeatable database objects
27:26 Migrating tables
36:05 Requirements for migration scripts
38:50 Use an existing logging framework!
40:13 Q&A: Recompile invalid objects after migration; 24x7 shop should use EBR; rely on flashback for undo; CI/D tools

Subscribe to give us feedback and be notified of upcoming sessions!

Having trouble watching the video on this page? Open the video in your browser.

Session Resources

Your Experts

Jasmin Fluri
Jasmin Fluri, Data Engineer    
Jasmin Fluri works as a software and data engineer at Schaltstelle GmbH. She lectures on software engineering and code review at the University of Applied Sciences North-Western Switzerland. In her projects she focuses on continuous integration and delivery pipelines, automation of recurring tasks, PL/SQL development, testing, data engineering and data warehousing. She is part of the Oracle ACE Program as an Oracle ACE.
Steven Feuerstein
Steven Feuerstein, Developer Advocate for PL/SQL    
Steven Feuerstein leads a team of Developer Advocate at Oracle Corporation, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). He's published over 1400 quizzes on PL/SQL at the Oracle Dev Gym.