Please, post to a single mailing list at a time in the future. I've done such migration in the past. I don't recommend attepting to migrate the SQL between dialects. That is a sure way to run into much trouble as there are many minor differences between the schemas.
You can relatively easily do an AIP export [1] of the whole site from your Oracle repository and import the AIP into your DSpace/Postgres installation. Of course, I recommend you to install a new empty DSpace/Postgres on a separate machine in parallel with the old one before you do the migration. In general, I recommend against in-place upgrades. Once you succeed migrating the contents, you may want to migrate the usage data (Solr statistics), too. I described my migration process here [2]. That one is specific to DSpace 5. Keep in mind that newer versions use UUIDs as internal identifiers for objects, so there will be some modifications needed. [1] https://wiki.duraspace.org/display/DSDOC6x/AIP+Backup+and+Restore [2] https://wiki.duraspace.org/pages/viewpage.action?pageId=70584988 Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette On Mon, Aug 14, 2017 at 12:28 PM, Nicola Di Marzo <[email protected]> wrote: > Hi All, > > We are evaluating the option to migrate our Dspace environment from Oracle > to PostgreSQL. > > > I wonder if someone already went through such migration and could provide > feedback in order to point me in the right direction. > > > I know there is a script available to export the Oracle database - ora2pg: > > http://ora2pg.darold.net/start.html > > Many thanks in advance for any thought! > > > -- > Kind Regards, > > Nicola Di Marzo > > Linux System Administrator/Applications Analyst, IT Services > > Room TB.102 > > Queen Mary, University of London > > Tel: +44 (0) 20 7882 3481 > > Email: [email protected] > > Worried about Cyber Security? Check this out - Cyber Security Information > and Training > > Queen Mary is committed to reducing its carbon footprint. Please only print > this email if absolutely necessary. > > -- > You received this message because you are subscribed to the Google Groups > "DSpace Community" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/dspace-community. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/dspace-tech. For more options, visit https://groups.google.com/d/optout.
