Hello Vineet, You may be better off asking on Oracle mailing lists how to migrate from PostgreSQL to Oracle, as that seems like the hardest part of this migration. I'm unaware of any tools that make this easy, but there seems to be some discussions about migrating from PostgreSQL in the Oracle Community Directory:
https://community.oracle.com/search.jspa?q=migrate+from+postgresql&customTheme= Unfortunately, DSpace has no easy way to help you with such a database migration. But, if you were willing to upgrade to DSpace 5.1 + PostgreSQL FIRST, then you could use DSpace's export tools to simply export all its content, and then re-import it into a new copy of DSpace 5.1 + Oracle. That process of exporting content from DSpace 5.1 + PostgreSQL & reimporting into DSpace 5.1 + Oracle would look like this: 1) First upgrade from DSpace 1.4.1 to DSpace 5.1 (keeping the database on PostgreSQL during this upgrade) 2) Export all the content as AIPs from DSpace 5.1 + PostgreSQL. See this command: https://wiki.duraspace.org/display/DSDOC5x/AIP+Backup+and+Restore#AIPBackupandRestore-ExportingEntireSite 3) Install a fresh (empty) version of DSpace 5.1 + Oracle. 4) Finally, *Import* all the AIPs (which were exported in step #2) into the DSpace 5.1 + Oracle instance. See this command: https://wiki.duraspace.org/display/DSDOC5x/AIP+Backup+and+Restore#AIPBackupandRestore-RestoringEntireSite Good luck, Tim On 5/19/2015 1:10 AM, Vineet Kumar Rakesh wrote: > Dear Sir, > > Old Dspace Installation Details (Running Live):- > > OS - Red Hat Enterprise Linux ES release 3 > Dspace -version 1.4.1 > database - postgresql-8.2.3 > > We changed the physical server due to storage etc. constraint thatwhy > we installed new server with following details > > New Dspace Installation details: > > OS- RHEL 6.5 > Dspace 5.1 (xmlui) > Database- Oracle 11gR2. > > I want to migrate the data from old dspace postgresql-8.2.3 to new > dspace oracle 11g R2 database(central database). Please help to do this > and also mention all simple steps. Thank you in advance > > with best regards, > > विनीत कुमार राकेश / vineet kumar rakesh > तकनीकी अधिकारी / Technical Officer > परिवर्ती उर्जा साइक्लोट्रॉन केंद्र / Variable Energy Cyclotron Centre > परमाणु उर्जा विभाग / Department of Atomic Energy > भारत सरकार / Government of India > 1/ए एफ विधान नगर / 1/AF Bidhan Nagar > कोलकाता - 700064 , भारत / Kolkata - 700064, India > > > टेल./ Tel: +91 33 2318 2206, 9330984666 > फैक्स / Fax: +91 33 2334 6871 > ईमेल / Email : vin...@vecc.gov.in > > > ------------------------------------------------------------------------------ > One dashboard for servers and applications across Physical-Virtual-Cloud > Widest out-of-the-box monitoring support with 50+ applications > Performance metrics, stats and reports that give you Actionable Insights > Deep dive visibility with transaction tracing using APM Insight. > http://ad.doubleclick.net/ddm/clk/290420510;117567292;y > > > > _______________________________________________ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech > List Etiquette: > https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette > ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
