Skip to main content
Question

We have several on prem Oracle 19c databases (10.6.1) that we want to Migrate to 10.9.1 postgres databases in AWS. Has anyone done something similar using FME?

  • December 20, 2022
  • 1 reply
  • 32 views

Forum|alt.badge.img

So far in searching I've only found instances where the Oracle DB was dumped into file geodatabases via copy and paste. Then another copy and paste into the target DB.

 

Sort of a part two question:

Regardless of the method used for the migration is it possible to process deltas from Oracle to Postgres directly?

1 reply

danminneyatsaf
Safer
Forum|alt.badge.img+12

Hi @jlgvii​ if you're looking to migrate data from an Oracle database to Postgres database, I recommend taking a look at these two articles:

Both articles describe in detail how you can use Change Detection in FME to process deltas, and only Update/Insert the data that needs to be processed.

 

Hope this helps! Let me know if you have any other questions.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings