3

I am new to databases.

Is it possible to migrate from Oracle database to Postgres?

If yes, do you know any tested solutions?

2
  • There does not appear to be a GIS component to this pure DBMS question.
    – PolyGeo
    Jun 3, 2018 at 6:47
  • We migrated content from an Oracle database (>100 schema; >1000 tables, many with millions of rows) to Postgres using the (hacky!) approach at: github.com/MIT-LCP/oracle-to-postgres.
    – tomp
    Jun 4, 2018 at 14:30

1 Answer 1

6

libogr can read and write both Oracle and PostGIS. Use the ogr2ogr utility to convert your data.

Works well enough for us.

2
  • Is it working regardless to database size?
    – com
    Apr 11, 2011 at 13:26
  • 2
    I'm certain you can break it. Our main vector database has ~40M records in its largest table and a size of ~260GB.
    – relet
    Apr 11, 2011 at 13:32

Not the answer you're looking for? Browse other questions tagged or ask your own question.