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?

  • 20 December 2022
  • 1 reply
  • 3 views

Badge

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

Userlevel 2
Badge +9

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.

Reply