Module 18 - Migrating Oracle Objects to EDB Postgres Advanced Server

Module Objectives

Oracle to EDB Postgres Advanced Server Migration

Migration Process

Migration Assessment

Assessing Migrations - Identify Candidate Databases

Migration Assessment Methodology

Database Migration Assessment Tool (DMAT)

DMAT - Features

DMAT - Architecture

DMAT - Report

Reading the Migration Assessment Report

DMAT - Available Solutions

Demo - DMAT

Database Migration

Database Migration - Preparation

Information Collection

EDB Postgres Migration Toolkit

EDB Postgres Migration Toolkit - Features

EDB Postgres Migration Toolkit - Objects Matrix

EDB Postgres Migration Toolkit - Installation

EDB Postgres Migration Toolkit - Graphical Installation

EDB Postgres Migration Toolkit - StackBuilder Installation

EDB Postgres Migration Toolkit - Select Target Server

EDB Postgres Migration Toolkit - Application Selection

EDB Postgres Migration Toolkit - Installation Steps

Demo - Installing MTK

EDB Postgres Migration Toolkit - Source-Specific Drivers

Example - Source-Specific Drivers

Demo -Source Specific Drivers

EDB Postgres Migration Toolkit - Prepare a Connection

EDB Postgres Migration Toolkit - Perform Migration

EDB Postgres Migration Toolkit Options

EDB Postgres Migration Toolkit Options (Continued)

EDB Postgres Migration Toolkit - runMTK Command

EDB Postgres Migration Toolkit - What's Migrated

EDB Postgres Migration Toolkit - Offline Migration

EDB Postgres Migration Toolkit - What's Migrated

Demo - Migration

Migration Toolkit - Looking for Errors

Application Migration

Application Migration

Deployment

Deployment

Deploy - Postgres Enterprise Manager

Ongoing Management and Optimization

EDB Migration Methodology

Module Summary

Lab Exercise