Forum OpenACS Q&A: Postgres 7.2.3 Data to Oracle 8.1.7
openacs 4.6/dotlrn 1.0 on Linux to Oracle on Solaris.
Is there a way to do this?
What character set should i use when creating the oracle database (postgres was configured with --enable-locale --enable-multibyte)?
Thanks for any comments!
Granted, CREATEs are not going to be perfect -- some tweaking may be required.
I can't imagine any reason to move an OpenACS site from Linux to Solaris. Usually people go the other direction.
I can imagine reasons to switch from PostgreSQL to Oracle (a few features Postgres lacks), but I can imagine reasons to go the other way too (including a few features Oracle lacks). And I don't know of anyone who's made a Postgres to Oracle migration, everyone using PostgreSQL with OpenACS seems happy with it.
Andrei, I would be very surprised if you'd be able to load a PostgreSQL dump into Oracle without major changes. Why else would OpenACS use completely separate Oracle and PostgreSQL versions of the *.sql package data model install files?
Actually there are a number of reasons that someone might consider using Solaris over Linux.
One might be the "lights out management" feature of some SPARC machines, where you can completely control the system remotely, even booting it.
Further, Oracle on Solaris is usually considered the very most stable and reliable way to run Oracle. This may change in the future of course as Oracle puts more emphasis on Linux.
In Haus Solaris Guru (with beard)
In Haus Oracle Guru (with mustache)
That are there to help. It is a question of long term maintenance. These guys have been playing with Solaris and Oracle for years. Experienced firemen.