Page History

...

1. Open command line and move to following directory:
   C:\Strawberry\perl\site\bin.
2. Execute command line ora2pg to launch migration script from Oracle to SQL files for PostgresSQL objects creation.
3. Create a database on PostgreSQL server
   1. Use extension « pgcrypto »
      Image Added
      
      
   2. And select an appropriate owner for the database (ex: dspace)
      Image Added
      
      
4. Execute obtained SQL scripts as « dspace » using the above mentionned command in point 2.
5. For a SQL script that is too large, it is necessary to use the following commands in admin mode:
   1. SET PGCLIENTENCODING=utf-8
   2. psql -h localhost -p 5432 -U dspace -d dspace -f INSERT_output.sql 1>out.txt 2>err.txt
      

      Image Added
      Image Added
      Warning: You must have previously defined a password for the user “dspace”. When clicking on OK, you will be prompt for this password.
      
      

6. Replace content of the « schema_version » table, doing a « truncate » and using the import function in the PostgreSQL admin tool. The file to import is csv. You will have to use “comma” as delimiter and select that there is a Header in the file. In the 2nd tab, use NULL as value for empty strings.
7. Run scripts SQL_FUNCTIONS.sql and SQL_SEQUENCES.sql.
   Note: These 2 file are a local one.
8. Run script 0__DS-2701_xml_workflow_migration.sql.
9. Run script 0__DS-2701_data_workflow_migration.sql.
10. Run script SQL_TABLES.sql.
    Note: This file is a local one.
11. (Optionnal), backup the database and run the migration program to DSpace 7.2 as documented on DSpace 7 Documentation: https://wiki.lyrasis.org/display/DSDOC7x/Upgrading+DSpace.

...