migrate oracle to oracle cloud.

First learn the price list of Oracle. It is i will say  ... expensive.

here are many documents that can help you in respect to technical details.

schwertner ,

First learn the price list of Oracle. It is i will say  ... expensive.

knew it is very expensive! we just have an oracle upgrade project and project quote the cost alreayd ! tha'ts why we here has the option to migration from oracle to other DB. cut cut cut cost!

https://cloud.oracle.com/en_US/data-mgmt 

no no, i a,m refer to a much closer to offical guide on how to mgiration exisitng oracle DB to oracle cloud.

Your Oracle Account team will be more than happy to help you with the best ways to get you into their Cloud.

For self research, I would probably start here:
https://www.oracle.com/database/technologies/cloud-migration.html

There is a list in the section:  Oracle Database Cloud Migration Solutions

Your Oracle Account team will be more than happy to help you with the best ways to get you into their Cloud.

haaha, they will be ! but I don't want to fool by them...…  this is what I don't want ! 

Oracle Zero Downtime Migration is a tools ? might be just like MS DMA or DMS. it is 2.7GB.

it has a complete procedure on doing it inside ? did you do it before? what is the difficulty you experienced ?

found this one:

https://azure.microsoft.com/zh-tw/resources/videos/overview-of-migration-and-recommended-tools-services/

might be a good single source of information on how to migrate to Azure.

We're not using the Oracle Cloud and are moving away from Oracle.

ahaahah, same as a lot of people here ! so what DB are you using ? MS SQL ? here a lot of case using MS SQL here from Oracle, specially banking ! big bank.

We are currently looking into Postgresql.  More specifically, AWS RDS and/or Aurora.

We are currently looking into PostgreSQL.

very good as I have a question on this ! why PostgreSQL ? as it is always refer to open source Oracle ? a senior developer share this with me.

but open source DB always can't failover to a remote site by design ..

this exercise just to cut cost a lot,,? your system should not too much loading for open source DB to handle ?

Cost was a factor in the decision.  The main factor was moving from on prem systems to the cloud.  AWS was sort of chosen for us.  Postgres because it is allowed in RDS and pobably because it is similar to Oracle.

My project's database is about 1TB and is a hybrid of OLTP and DSS.  My organization does have some rather large databases that are also looking to move.  So far our performance on the OLTP side seems reasonable.  Some DSS processing isn't quite what I expect but tuning Postgres is still new to all of us.

AWS RDS has some automated failover capability.  I, personally, haven't experimented with it to see it it works as documented so cannot comment on that.  We'll eventually have to look into it.  We just aren't there yet.

We are also looking at Aurora.

Postgres because it is allowed in RDS and probably because it is similar to Oracle.

Postgres is only allowed in RDS and not azure ? but it should not be the key factor, right? and the only thing is ONLY this DB is similar to oracle ?but in terms of what ? PL/SQL ? don't tell me it has ASM and RAC!


"Some DSS processing isn't quite what I expect but tuning Postgres is still new to all of us."

you mean still a lot of tuning in PostgreSQL is acceptable ?

" We are also looking at Aurora. "

what goods is it ? why not MariaDB and MySQL ?

"AWS RDS has some automated failover capability"

so by this you relies on the cloud to failover for you on this kind of DB do not have failover capability  ?

after migration need tuning is reasonable but I just wondering the reason behind !

and you mean just because it is a post migration task you are learning how to do ?

>>after migration need tuning is reasonable but I just wondering the reason behind !

Data changes which means behaviour changes.  There is a job title Database Administrator for a reason.  Someone needs to ensure optimal performance and uptime.

If you have a car, does it just "work" or do you need someone to perform maintenance to ensure optimal performance?

ok, just a formal post configuration/installation task for this kind of data migration, tks.

quite generic !