Versions Compared

Old Version 12

changes.mady.by.user Pierre Lasou

Saved on

compared with

New Version 13

changes.mady.by.user Tim Donohue

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Moved Oracle to Postgres migration to a subpage

...

  • Intro to DSpace (August 19, 2009) - written by Cameron Kainerstorfer and Heather Perkins (both of University of Texas Southwestern Medical Center)
  • The DSpace Course (August 2008) - written by Stuart Lewis and Chris Yates, funded by JISC and Repositories Support Project and was funded by JISC  
  • Instructions for New Admin - This is a simple guide to print off for people who will start uploading documents to your instance of DSpace, by Shawna Sadler.

DSpace Oracle to PostgreSQL migration

The following procedure is only one example of migration done from Version 6.3 to Version 7.2.

It has been made using Ora2pg: https://ora2pg.darold.net/documentation.html

...

  • Unzip and access the file from the command line

...

  • C:\Strawberry\perl\site\bin
  • C:\ora2pg
    Note : Do not use another path for Ora2Pg, otherwise configuration will not be made correctly in Strawberry Perl.

...

  1. Modify variable ORACLE_HOME to point to Oracle client
  2. Modify string connexion to Oracle DB :
    1. User/Password
    2. ORACLE_DSN, ORACLE_USER, ORACLE_PWD
  3. TYPE = TABLE,SEQUENCE,INSERT
  4. UUID_FUNCTION = gen_random_uuid
  5. STOP_ON_ERROR = 0
  6. FKEY_DEFERRABLE = 1
  7. DEFER_FKEY = 1
  8. MODIFY_TYPE 
    bitstream:size_bytes:bigint,checksum_history:check_id:bigint,checksum_history:checksum_expected:varchar,checksum_history:checksum_calculated:varchar,checksum_history:result:varchar,checksum_results:result_code:varchar,checksum_results:result_description:varchar,harvested_collection:oai_source:varchar,harvested_collection:oai_set_id:varchar,harvested_collection:harvest_message:varchar,harvested_collection:metadata_config_id:varchar,harvested_collection:harvest_start_time:timestamp with time zone,harvested_collection:last_harvested:timestamp with time zone,harvested_item:last_harvested:timestamp with time zone,harvested_item:oai_id:varchar,item:last_modified:timestamp with time zone,metadatavalue:text_lang:varchar(24),most_recent_checksum:expected_checksum:varchar,most_recent_checksum:current_checksum:varchar,most_recent_checksum:checksum_algorithm:varchar,most_recent_checksum:result:varchar,resourcepolicy:start_date:date,resourcepolicy:end_date:date,webapp:url:varchar,webapp:isui:integer
  9. REPLACE_AS_BOOLEAN NUMBER:1 CHAR:1
  10. DATA_TYPE NUMBER(*\,0):integer,VARCHAR2(2000):text
  11. SCHEMA DSPACE

Data migration procedure :

...