postgresql migration tool, PostgreSQL migration to cloud

Mastering the Migration to PostgreSQL

Mastering the migration to PostgreSQL

Buy $599.00 Free Preview

Course curriculum

1. About the course
  FREE PREVIEW
1. Overview of Migration from Oracle to PostgreSQL
2. Assessment and Planning Phase in Migration from Oracle to PostgreSQL
3. Setting Up PostgreSQL Environment for Oracle to PostgreSQL Migration
4. Data Migration Phase in Migration from Oracle to PostgreSQL
1. Top 100 Questions on Migration from Oracle to PostgreSQL
1. VM Migration Overview
2. VM Migration Strategies
3. VM Migration Tools and Resources
1. When to use pg_dump/psql, pg_dumpall/psql, pg_dump/restore & copy tools for migration to RDS
2. Getting started and launching an Ec2 Instance as source
3. How to Migrate PostgreSQL database using export and import
4. How to Migrate PostgreSQL@VM PostgreSQL@RDS pg_dump/psql
5. How to Migrate PostgreSQL@VM PostgreSQL@RDS pg_dumpall & psql
6. Concept- Migration of PostgreSQL running on VM to RDS via pg_dump and pg_restore
7. Migration of PostgreSQL running on VM to RDS via pg_dump and pg_restore - Objects in wrong DB
8. Migration of PostgreSQL running on VM to RDS via pg_dump and pg_restore - Objects in correct DB
9. Migrating to RDS PostgreSQL via copy command
10. Script
1. Migration to RDS PostgreSQL - Online Homogenous Migration
2. Concept -What is Logical Replication in PostgreSQL ?
3. Logical Replication - Technical points
4. Logical Replication between Pg14 to Pg16
5. Logical Replication between Pg14 to RDS-Pg16
1. What is AWS Database Migration Service?
2. High-level view of AWS DMS
3. Components of AWS DMS
4. Supported Source Data Stores for AWS DMS Features
5. Supported Target Data Stores for AWS DMS Features
1. What is Ora2Pg ( Oracle to PostgreSQL Migration tool )
2. Features of Ora2Pg tool
3. Installing Ora2Pg on existing Oracle Database
1. Lecture: Oracle database to PostgreSQL Migration ( Planning)
2. Demo : Prepare Source Oracle Database
3. Demo: Install Ora2pg on CentOS 7.5 and establish a connection with the Oracle 12c database.
4. Ora2pg Configuration file and establish a connection with the Oracle 12c database.
5. Demo : Working with Ora2pg --init_project name & --project_base dir in Ora2pg
6. Demo: Running a migration report of Ora2pg
7. Demo :Generate DDL scripts from Oracle database
8. Demo: Prepare target PostgreSQL version Pg16
9. Create DDL objects and load data in PostgreSQL
10. Export data from Source Oracle database
1. Oracle to PostgreSQL migration (Oracle Hr Schema migration to Pg HR database)
2. Assignment
3. QNA
1. Oracle to PostgreSQL migration (Oracle sales_history Schema migration to Pg sales_history database) without Partitioing
2. Oracle to PostgreSQL migration (Oracle sales_history Schema migration to Pg sales_history database) WIth Partitioned table
3. Oracle to PostgreSQL migration ( sales_history Schema with partitioned table) 2 Partitioned table
1. Oracle to PostgreSQL migration ( sales_history Schema with partitioned table) 2 Partitioned table
2. Understanding Oracle_DSN and PG_DSN in ora2pg
3. Best Practices for Installing ora2pg Tool
4. Configuration Directives for Accessing Oracle Database
5. Understanding FKEY_DROP in ora2pg.conf File
1. Oracle database to PostgreSQL Migration ( Planning) using SCT+DMS
2. Demo : Prepare Source Oracle Database 19c with SH/HR Schema+data
3. What is AWS Schema Conversion Tool (AWS SCT)
4. Demo: Install SCT on Windows and establish a connection with the Oracle 19c database.
5. Demo: Prepare target PostgreSQL version Pg16
6. What is AWS Database Migration Service?
7. Demo: Lauch DMS by spinning up the replication instance
8. Demo :Endpoints creation and connection testing with DMS
9. Demo : DMS Report creation pre-migration
10. Demo: Migrate the Schema from Oracle to PostgreSQL using SCT
11. Demo: Migrate the Data from Oracle to PostgreSQL using DMS
1. AWS sample database Migration from Oracle to PostgreSQL using SCT+DMS
1. Overview of Migration of MYSQL to PostgreSQl RDS using SCT+DMS
2. Prepare Source MYSQL RDS and a client to load data
3. Demo: Prepare target RDS@PostgreSQL version Pg16
4. Demo: Migrate the Schema from MySQL to PostgreSQL@RDS using SCT
5. Demo: Launch DMS replication instance
6. Demo :Endpoints creation and connection with DMS
7. Demo: Migrate the Data from MySQL RDS to PostgreSQL RDS using DMS ( Migration task)

About this course

$599.00
72 lessons
15 hours of video content

Mastering the Migration to PostgreSQL

Course curriculum

About the course

Migrating to PostgreSQL: Introduction

Known , Unknown & Frequently asked questions

Migrating to PostgreSQL: VM Migration

Migrating to RDS PostgreSQL - Offline Migration

Migrating to RDS PostgreSQL - Online homogenous Migration

AWS Database Migration Service

Oracle To PostgreSQL Migration

Oracle to PostgreSQL migration

Oracle HR Schema miration to PostgreSQL HR database using Ora2pg

Oracle sales_history Schema miration to PostgreSQL sales_history database using Ora2pg

Critical terms related to Ora2pg migration tool

AWS DMS MIGRATION OF ORACLE to PG16

Oracle to Postgresql with AWS Sample database-30 GB Migration

MySQL to PostgreSQL Migration with sample database using SCT+DMS

About this course