1

I can migrate Oracle SQL table to PostgreSQL using ogr2ogr using:

ogr2ogr -progress -f "PostgreSQL" -nln schema.table -skipfailures -overwrite -lco FID=ID_COLUMN -lco GEOMETRY_NAME=geom PG:"host=localhost user=postgres password=yadayada dbname=database" OCI:username/password@server:port/database:schema.table

Is there a way to copy the whole schema?

Improve this question
2
  • No, or better: not easily. The proprietary FME can do that in batch, but you'd need a license. This blog article might help you save some time running ogr2ogr for each table in a schema. Commented Jul 9, 2019 at 8:14
  • You can use scripting to run the conversion command for each table you want to move. Python for example: use it to build a lcatalof of tables to copy, then for each table construct the ogr command and execute it. You can also record progress: mark the catalog rows with success or failure, record timings etc Commented Jul 10, 2019 at 4:06

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.