Efficient way to load bulk data from Oracle to PostgreSQL

Databases
1

I am looking for a better way in performance to handle bulk data from remote Oracle into PostgreSQL in local ( 50,000 rows ).
(Windows application).
Currently, just using PreparedStatement and insert the data in a loop with a RecordSet.

Dim ps As PostgreSQLPreparedStatement

Thinking of generating a file and load it into PostgreSQL by psql command.

I am wondering if there is any other nice method to improve this logic.
Memory processing or by Dictionary?

2

Don’t know if you want to do it in Xojo, if you can use an external utility check for Ora2Pg http://ora2pg.darold.net/index.html

3

These links might help you.

https://www.postgresql.org/docs/current/populate.html

https://www.postgresql.org/docs/12/sql-copy.html