Hi all, This is what I tried before, using the batch export and import. However, there were many problems there as well. The community, collection, user and usersgroups have to restored manually. All dates and handles would change, causing these to be marked as new for all services who harvest us. And the import threw many errors. So, I gave up on that approach.
But I would be interested to hear about the changes you made. Best wishes, Francis Brouns -----Oorspronkelijk bericht----- Van: Ricardo Borillo [mailto:[email protected]] Verzonden: dinsdag 9 februari 2010 14:44 Aan: Brouns, Francis CC: Khan, Baseer; [email protected] Onderwerp: Re: [Dspace-tech] Database and Server Migration Hi Baseer, To avoid database interoperability issues, an option could be: *. Create a fresh installation with Oracle backend. *. Export all collections with "export" command from the 1.4.2 repository. *. Import all collections with "import" command to the new fresh Oracle installation. I haven't tried this scenario ... Do you think this could be an option? Note: We have modified "export" command to work properly with communities, so the process could be done at a high level ... --- Salut, ==================================== Ricardo Borillo Domenech http://xml-utils.com On Tue, Feb 9, 2010 at 10:46, Brouns, Francis <[email protected]> wrote: > Hi, > > we are doing the same, although we run SLES. Migrating the data to Oracle is > a pain, as I do not have a ICT developer who could assist and we are > manually importing the data. We dumped every table from Postgresql using the > insert into values syntax. Be sure to do that, because columns positions > have changed over time. Than there are all kinds of problems, when you use > SQLPlus to import the data. The & in text fields is interpreted as command > line parameter input; so you have to SET DEFINE OFF. There are problems with > the tables using a timestamp. In particular with the metadatavalue table > there are many problems when fields contain whitespace, the ; character, > empty lines without content, records containing more than 2499 characters, > fields containing more than 4K of text. The empty string in the records in > most_recent_checksum table are seen as NULL and can''t be inserted into the > NOT NULL column, and plenty more. > > I would appreciate hearing your experiences. > Best wishes, > Francis > > > ________________________________ > Van: Khan, Baseer [mailto:[email protected]] > Verzonden: maandag 8 februari 2010 19:14 > Aan: [email protected] > Onderwerp: [Dspace-tech] Database and Server Migration > > Hello , > > We want to upgrade our Dspace server on a new machine , > > Right now we are running it on RHEL 3 with postgres and tomcat , > > What we want to do here is we want to upgrade it to RHEL 5 , and migrate to > Oracle. > > The current version of Dspace is 1.4.2. > > Is it possible to migrate our database from Postgres to Oracle , Can anyone > help me in this migration. > > Can you advise on best practices and the pit falls to look for migration to > new server too. > > Thank you, > > Baseer. > > ------------------------------------------------------------------------------ > The Planet: dedicated and managed hosting, cloud storage, colocation > Stay online with enterprise data centers and the best network in the > business > Choose flexible plans and management services without long-term contracts > Personal 24x7 support from experience hosting pros just a phone call away. > http://p.sf.net/sfu/theplanet-com > _______________________________________________ > DSpace-tech mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/dspace-tech > > ------------------------------------------------------------------------------ SOLARIS 10 is the OS for Data Centers - provides features such as DTrace, Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW http://p.sf.net/sfu/solaris-dev2dev _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
