Discussion Locked

Cloud database migration

0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

For an organization that has several decades of intellectual property invested in Oracle hardware (Exadata) and software (business logic in PL/SQL, ETL, apps, external system integrations, etc.), as well as dipping their toe in AWS using basic services like compute (EC2) and storage (S3), what is a realistic strategy to "move the database to the cloud"?

A large migration to AWS RDS or Snowflake, etc. would involve rewriting and testing tons of code, this could take months or years. Oracle's Cloud Service would appear to provide a seamless migration path, albeit at a price. On the other hand, leaving technlology aside, management tends to dislike Oracle's heavy handed and costly licensing practices.

What are some realistic options here?

6 replies

by rproffitt

It's still going to cost so my experience is that unless you can move to your own SQL server you don't drastically reduce the costs.

Why do you think MySQL is so popular?

Again, the cloud is someone else's computer. This company knows how much servers are and they are actually cheaper from what I've experienced.

-> Change is hard. But moving from one SQL to another is usually the least of the worries. I can't guess what Oracle products they use but if they use Oracle Accounting or such then they are usually stuck with that for life.

by kees_b

Surely your account manager at Oracle can tell you how much switching to their cloud will cost, and how the Exadata hardware fits in the scheme or will be replaced.

I don't think it's realistic to move everything to another cloud then Oracle offers. Assuming it's technically and financially possible, what would the advantage be? And how much cost increase (if any) would that advantage be worth?

by deborasumopayroll

A database migration service supports multiple secure, private connectivity methods to protect your data-in-transit. Once migrated, all data is encrypted by default, and Cloud SQL provides multiple layers of security to meet even the most stringent security requirements. There are many reasons you might want to move to a different platform. For example, a company might decide to save money by moving to a cloud-based database.

Steps for Migrating Databases to the Cloud
Assess your current data environment.
Assess the skills & expertise of your internal team.
Select the right migration tools.
Deploy a proof of concept.
Review your data and reclassify it if necessary.
Cleanse your data.
Rebuild your database schema.
Migrate, validate, and repair your data.

by tanviagarwal1955

I migrate my blog data on the cloud, but IDK when I restore it I got half of the articles live only and some of the images are not visible.

[i]Useless link to site removed by moderator.[/i]

by kees_b

Sorry to read your experiences. All I can advise: find out where it went wrong and do it better a second time.

This discussion is closed to new replies.