Now with Cloud, many customer want to move their database On-Prem to some clouds as AWS, Oracle and IBM. Here I describe the differences if you want to move your Oracle database On-Prem to Amazon AWS.
EC2: You manage the database at AWS by yourself.
RDS (RELATIONAL DATABASE SERVICE) : Database as a Service (DBaaS) that automatically configures and maintains your databases in the AWS cloud. The user has limited power over specific configurations .
Then if the customer chooses for EC2 you have these migrations options:
Migrating Oracle database to EC2:
- RMAN backup restore
- Platform
- Version
- Golden gate
- EC2 Instance for Golden Gate
- Zero Downtime
- Cost
- Database Migration Service
- Most cost effective
- Zero Downtime
- Data Guard
- Zero Downtime
Otherwise if the customer wants RDS:
Migrating Oracle to RDS:
Data Pump:
- Cross Platform
- Cross version
Golden Gate (additional licences)
- EC2 instance for replicat process
- Zero Downtime
- Cost
Database Migration Service (most cost effective)
- Most cost effective
- Zero Downtime
These options also impact in some Oracle options:
Oracle Rac is not supported in RDS. (RAC: ACTIVE X ACTIVE, RDS: ACTIVE X PASSIVE)
ASM supported both EC2 and RDS.
Multitenant is not supported in RDS just EC2.
Data Guard is not supported in RDS just EC2.
Also in some application:
PeopleSoft: support EC2 and RDS;
Siebel: support EC2 and RDS;
JD Edwards: support EC2 and RDS;
ISV Applications : support EC2 and RDS
E-BUSINESS SUITE: Application who needs to access the file system which is not provided by RDS so just EC2 is supported.
*The views expressed here are my own and do not represent those of my employer.*
Hello, I’m Bruno — a dual citizen of Brazil and Sweden. I bring a global perspective shaped by experiences in both South America and Europe, with a strong focus on collaboration and innovation across cultures. I am a Computer Scientist, PhD Candidate in Information and Communication Technologies, focusing on Data Science and Artificial Intelligence, and hold dual Master’s degrees in Data Science and Cybersecurity. With over fifteen years of international experience spanning Brazil, Hungary, and Sweden, I have collaborated with global organizations such as IBM, Playtech, and Oracle, as well as contributed remotely to projects across multiple regions. My professional interests include Databases, Cybersecurity, Cloud Computing, Data Science, Data Engineering, Big Data, Artificial Intelligence, Programming, and Software Engineering, all driven by a deep passion for transforming data into strategic business value.