copy data between databases

[Hans Nieuwenhuis]

Hi,

I am looking at copying data between Oracle and postgres database.
This is not for migration, but to get some data from the other database and use that.
Will be done once a day or so.

I am thinking about a headless client.

But what is the best way to actually copy the data ?
- copy foundsets
- copy datasets
- copy records

Regards,

[david]

Creating records in mass with Servoy is not fast. If you must, this technique is the way to go: http://www.servoymagazine.com/home/2013 ... lugin.html.

Better to grab your data via dataset or foundset and write out your own sql file of insert statements. Can load PostgreSQL using this file with the sql plugin or triggering a command line app.

Another option is to replicate Oracle to PostgreSQL. A few tools out there for this.

If you don't have a lot of records, then creating records through foundset has one gotcha: reset the destination foundset to empty every several hundred records or so. Creating records in foundsets gets slower as the foundset gets bigger.