Page History
...
- Start with the DSpace Documentation.
- Platform and distribution-specific tips and guides can be found on the DSpace Installation Guides page.
- en español: Instalación de Dspace: Deploy de un repositorio básico con Dspace 3.0
- DSpace Oracle to PostgreSQL migration - A general guide to migrating from Oracle to PostgreSQL
Customizing DSpace
- Past Training Materials & Workshops:
- DSpace Training Archives - This is our primary archive of past workshop/webinar materials.
- DuraSpace webinar archive, DuraSpace Slideshare - additional workshops/webinars hosted by DSpace
- DSpace YouTube - Some DSpace related videos (and past meetings/summaries)
- General Tips:
- How-To Guides has a list of all wiki pages which provide "how-to" hints for changing/customizing your DSpace install.
- Build Cookbook has examples of adding your local changes to a DSpace distribution.
- Additional training in spanish: Curso de capacitación en repositorios y DSpace by SeDiCi, Universidad de la Plata, Argentina
...
- 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.
...
- Modify variable ORACLE_HOME to point to Oracle client
- Modify string connexion to Oracle DB :
- User/Password
- ORACLE_DSN, ORACLE_USER, ORACLE_PWD
- TYPE = TABLE,SEQUENCE,INSERT
- UUID_FUNCTION = gen_random_uuid
- STOP_ON_ERROR = 0
- FKEY_DEFERRABLE = 1
- DEFER_FKEY = 1
- 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 - REPLACE_AS_BOOLEAN NUMBER:1 CHAR:1
- DATA_TYPE NUMBER(*\,0):integer,VARCHAR2(2000):text
- SCHEMA DSPACE
Data migration procedure :
...
- Use extension « pgcrypto »
- And select an appropriate owner for the database (ex: dspace)
...
- SET PGCLIENTENCODING=utf-8
- psql -h localhost -p 5432 -U dspace -d dspace -f INSERT_output.sql 1>out.txt 2>err.txt
Warning: You must have previously defined a password for the user “dspace”. When clicking on OK, you will be prompt for this password.
...
- .
Overview
Content Tools