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
