Thanks very much for you reply.
Very interesting info, i will take a look.
Regards
Nicola
On 14/08/17 12:01, helix84 wrote:
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.
--
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] <mailto:[email protected]>
*Worried about Cyber Security? Check this out - Cyber Security
Information and Training
<http://connect.qmul.ac.uk/qmandyou/staff/items/2016/item177974.html>*
*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
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.
