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 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.
