Migration from 5.10 Oracle to 7.6 Postgres

[Luiz Antonio Cardoso Mendes]

Hello, I am trying to upgrade from 5.10 to latest 7.6 version. But my problem is a oracle database and trying migrate my data to postgresql using Ora2pg with Strawberry using the tutorial: https://wiki.lyrasis.org/display/DSPACE/DSpace+Oracle+to+PostgreSQL+migration

But this tutorial was used to migrate Oracle data in version 6.x the Dspace to 7.x. and may have different settings to be followed in version 5.

What would be the best option?
1 - Migrate the oracle data to postgresql in the Dspace 5 version data structure and then, with a new installation of version 7.6, update the database structure.
or
2- Update the Oracle database to version 7.6 and then migrate the Oracle data to Postgres?

What would be the best option?
1 - Migrate the oracle data to postgresql in the Dspace 5 version data structure and then, with a new installation of version 7.6, update the database structure.
or
2- Update the Oracle database to version 7.6 and then migrate the Oracle data to Postgres?

About the tutorial https://wiki.lyrasis.org/display/DSDOC7x/Migrating+DSpace+to+a+new+server
If I follow... it talks about pg_dump but it is for Postgres... can I do it in Oracle? What would be the correct sequence to execute and do this from Oracle?

[emilio lorenzo]

My vote for option 1.  Is better and easier to check the migrated tables in Dspace 5, you are mor familiar with that version. Once  checked, plan for version 7

Best luck

Emilio

--
All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx
---
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 dspace-tech...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/e1e038c4-12ca-411a-bcbe-52640d02b279n%40googlegroups.com.

[Michael Plate]

Hi,

Am 05.10.23 um 20:31 schrieb Luiz Antonio Cardoso Mendes:

> Hello, I am trying to upgrade from 5.10 to latest 7.6 version. But my
> problem is a oracle database and trying migrate my data to postgresql
> using Ora2pg with Strawberry using the tutorial:
> https://wiki.lyrasis.org/display/DSPACE/DSpace+Oracle+to+PostgreSQL+migration
>
> But this tutorial was used to migrate Oracle data in version 6.x the
> Dspace to 7.x. and may have different settings to be followed in version 5.

[…]

you could try to upgrade to DSpace6 the ususal way and follow the
tutorial to upgrade then to DSpace7.

Just my 0,0,2€

CU

Michael