Forum OpenACS Q&A: Re: Postgres 7.2.3 Data to Oracle 8.1.7

Collapse
3: Re: Postgres 7.2.3 Data to Oracle 8.1.7 (response to 1)
Posted by Andrew Piskorski on 09/24/03 10:46 AM
A more interesting question is, why do you want to do that?

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.

Collapse
6: Re: Postgres 7.2.3 Data to Oracle 8.1.7 (response to 3)
Posted by Patrick Giagnocavo on 09/24/03 02:43 PM
Andrew asks, why Solaris?

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.

Collapse
7: Re: Postgres 7.2.3 Data to Oracle 8.1.7 (response to 3)
Posted by Carl Robert Blesius on 09/25/03 08:24 AM
Some other reasons:

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.