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

Session Has Completed - 15 October 2020

Duration

1 Hour

Series Name

Location:

English

Products

Oracle PL/SQL

Featured Speaker Translation

Featured Speakers

Featured Speaker Translation

Join

Featured Speaker Translation

English

Featured Speaker Translation

Unregister

Featured Speaker Translation

Outline

Featured Speaker Translation

Objectives

Featured Speaker Translation

Resources

Featured Speaker Translation

15 October 2020

Featured Speaker Translation

Session Has Completed - 15 October 2020

Featured Speaker Translation

You Are A Speaker/Panelist

Featured Speaker Translation

1 Hour

Featured Speaker Translation

Pending

Featured Speaker Translation

Prerequisites

Featured Speaker Translation

Waitlisted

Featured Speaker Translation

Rejected

Featured Speaker Translation

Question And Answer

Featured Speaker Translation

Add To Calendar

Featured Speaker Translation

Registration Status

Featured Speaker Translation

Series Name

Featured Speaker Translation

Session Time

Featured Speaker Translation

You Are Registered. You Will Be Able To Join The Session 15 Minutes Before It Starts.

Continuous Database Migrations with PL/SQL

Workshop Info

Hidden Translations