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?
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.