[GUSDEV] migrate a gus3.0 oracle db to gus3.5 postgres?

[Michael C. <cha...@vc...>]

Does anyone have advice on how to migrate a gus3.0 oracle db to gus3.5 
postgres? My idea is:

We already have the 3.5 schema loaded in our postgres DB, all we need is 
the flat files (.csv, but seperated with tabs) exported from the Oracle 
DB and a copy of your Gus 3.0 schema. We should be able to create a new 
database, say gus30, load the old schema, load the files into it with 
something like:

copy <table> from '<path>' with NULL as '';

then, manually examine the differences in the two schemas and copy the 
tables from one database to the other that are the same, and (when they 
are different) make appropriate modifications before copying. However if 
the two schemata are radically different this may not be feasible. Does 
anyone know how different they are?