14 Oracle DB Migration Methods That Can Boost Your Career

As per the latest report , by 2025 80% percentage of mission critcial work load will be migrating to

Cloud.This also means that by 2025 , you may have to migrate most of , if not all , your Oracle

database to cloud.

AWS being the pioneer in cloud technology, it will be one of most favourite choice of most companies and

You being Oracle Database Administrator will be responsible for migrating your client database to AWS Cloud

This course will helping you in this migration process. In this course I have covered all the tools and methods

you should know for migrating on-premise database to AWS

You will be learning the following

• Oracle database in AWS

• Difference between Database on EC2 and RDS

• Creation of EC2 Instance

• Download Oracle Software In EC2 Instance

• Setting Up SSH Connectivity To EC2 Instance From On-premise

• Installation Of Oracle Software On EC2

• Provision of Oracle RDS Database

• Overview of Migration Methods

• Choosing the best migration method

• Understanding Endian and its impact on Migration

• Understanding Zero Downtime Migration

You will be mastering the following Migration Methods

1. Using SQL Developer to Migrate On Premise Database to AWS (Both EC2 and RDS)

2. Database Migration Using Data pump(Conventional)

3. Database Migration Using Transportable Tablespace

4. Database Migration Using Full Transportable Export and Import

5. Using RMAN CONVERT Transportable Tablespace with Data Pump for migration

6. RMAN Cross-Platform Transportable PDB

7. Migration Of PDBS by Unplugging/Plugging

8. Migration to RDS Using Datapump and DBMS_FILE_TRANSFER

9. Migration to RDS Using Datapump and S3 bucket

10. Zero Downtime Migration Using Goldengate

11. Migration To RDS Using AWS Database Migration Service