Legacy SQL → DSpace

National Research Foundation of South Africa

The National Research Foundation of South Africa set out to turn two legacy databases — 'Current and Completed Research Projects' and 'NRF Funded Projects' — into a modern research-information system by migrating them into DSpace. Because the legacy SQL systems needed bespoke scripting to extract, the project built a generic data mapper that automatically aligned idiosyncratic legacy fields with DSpace's Dublin Core schema. That tooling minimised manual work, letting administrative staff unfamiliar with DSpace ingest decades of historical funding data. A South African national-government example emphasising reusable migration tooling over hand-crafted, one-off crosswalks.

Original source
IR to RIMS: Transforming an Institutional Repository into a Research Information Management System
University of Cape Town (project archive)
The archived copy opens a snapshot on the Internet Archive's Wayback Machine, preserved for when the original moves or disappears.
The Archive Migration Review summarises this story in its own words and links to the original source for verification. We are editorially independent and not affiliated with the institution or software project named above. Summaries are compiled in good faith from publicly available accounts; corrections are welcome.
Keep reading

Related migrations