Emultiskills Database services

Overview of Migration from Oracle to PostgreSQL

Assessment and Planning Phase in Migration from Oracle to PostgreSQL

Setting Up PostgreSQL Environment for Oracle to PostgreSQL Migration

Data Migration Phase in Migration from Oracle to PostgreSQL

Top 100 Questions on Migration from Oracle to PostgreSQL

VM Migration Overview

VM Migration Strategies

VM Migration Tools and Resources

When to use pg_dump/psql, pg_dumpall/psql, pg_dump/restore & copy tools for migration to RDS

Getting started and launching an Ec2 Instance as source

How to Migrate PostgreSQL database using export and import

How to Migrate PostgreSQL@VM PostgreSQL@RDS pg_dump/psql

How to Migrate PostgreSQL@VM PostgreSQL@RDS pg_dumpall & psql

Concept- Migration of PostgreSQL running on VM to RDS via pg_dump and pg_restore

Migration of PostgreSQL running on VM to RDS via pg_dump and pg_restore - Objects in wrong DB

Migration of PostgreSQL running on VM to RDS via pg_dump and pg_restore - Objects in correct DB

Migrating to RDS PostgreSQL via copy command

Script

Migration to RDS PostgreSQL - Online Homogenous Migration

Concept -What is Logical Replication in PostgreSQL ?

Logical Replication - Technical points

Logical Replication between Pg14 to Pg16

Logical Replication between Pg14 to RDS-Pg16

What is AWS Database Migration Service?

High-level view of AWS DMS

Components of AWS DMS

Supported Source Data Stores for AWS DMS Features

Supported Target Data Stores for AWS DMS Features

What is Ora2Pg ( Oracle to PostgreSQL Migration tool )

Features of Ora2Pg tool

Installing Ora2Pg on existing Oracle Database

Lecture: Oracle database to PostgreSQL Migration ( Planning)

Demo : Prepare Source Oracle Database​

Demo: Install Ora2pg on CentOS 7.5 and establish a connection with the Oracle 12c database.

Ora2pg Configuration file and establish a connection with the Oracle 12c database.

Demo : Working with Ora2pg --init_project name & --project_base dir in Ora2pg

Demo: Running a migration report of Ora2pg

Demo :Generate DDL scripts from Oracle database

Demo: Prepare target PostgreSQL version Pg16

Create DDL objects and load data in PostgreSQL

Export data from Source Oracle database

Oracle to PostgreSQL migration (Oracle Hr Schema migration to Pg HR database)

Assignment

QNA

Oracle to PostgreSQL migration (Oracle sales_history Schema migration to Pg sales_history database) without Partitioing

Oracle to PostgreSQL migration (Oracle sales_history Schema migration to Pg sales_history database) WIth Partitioned table

Oracle to PostgreSQL migration ( sales_history Schema with partitioned table) 2 Partitioned table

Oracle to PostgreSQL migration ( sales_history Schema with partitioned table) 2 Partitioned table

Understanding Oracle_DSN and PG_DSN in ora2pg

Best Practices for Installing ora2pg Tool

Configuration Directives for Accessing Oracle Database

Understanding FKEY_DROP in ora2pg.conf File

Oracle database to PostgreSQL Migration ( Planning) using SCT+DMS

Demo : Prepare Source Oracle Database​ 19c with SH/HR Schema+data

What is AWS Schema Conversion Tool (AWS SCT)

Demo: Install SCT on Windows and establish a connection with the Oracle 19c database.

Demo: Prepare target PostgreSQL version Pg16

What is AWS Database Migration Service?

Demo: Lauch DMS by spinning up the replication instance

Demo :Endpoints creation and connection testing with DMS

Demo : DMS Report creation pre-migration

Demo: Migrate the Schema from Oracle to PostgreSQL using SCT

Demo: Migrate the Data from Oracle to PostgreSQL using DMS

AWS sample database Migration from Oracle to PostgreSQL using SCT+DMS

Overview of Migration of MYSQL to PostgreSQl RDS using SCT+DMS

Prepare Source MYSQL RDS and a client to load data

Demo: Prepare target RDS@PostgreSQL version Pg16

Demo: Migrate the Schema from MySQL to PostgreSQL@RDS using SCT

Demo: Launch DMS replication instance

Demo :Endpoints creation and connection with DMS

Demo: Migrate the Data from MySQL RDS to PostgreSQL RDS using DMS ( Migration task)