There is a workspace that copies a dataset from a production oracle database to a postgresql database. The postgresql database will be weekly updated with fme-server.
What is the fastest way to udate the postgresql database?
- check for the differences and write only these to the progressql database
- drop and create the table, so you write each time the complete dataset.
-or maybe another solution?
Thanks,
Kind regards Kees
Hoi @kees_v,
It depends on what you mean by fastest...
Option 1 is faster since you only update features that are changed, but 'discovering' these features is done in the workspace and therefore the workspace run time will be longer. Also this option is more error prone.
Option 2 is straightforward, no change detection which is 'safer' but might take longer. this also depends on the infrastructure that you are using for the workspace and the databases configurations.
If the update run time is not an issue ( running a schedule overnight) I would choose option 2.
Hope this helps,
Itay