Migration from Oracle to Postgresql

[Nicola Di Marzo]

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: n.di...@qmul.ac.uk

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.

[helix84]

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

> --
> 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 dspace-communi...@googlegroups.com.
> To post to this group, send email to dspace-c...@googlegroups.com.
> Visit this group at https://groups.google.com/group/dspace-community.
> For more options, visit https://groups.google.com/d/optout.