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 > > ------------------------------------------------------------------------------ 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
