On Sunday, October 6, 2002, at 11:56 AM, Tom Lane wrote:
> Transporting the data shouldn't be too hard. Porting your application
> from one DB to another can be painful, as everybody has their own set
> of
> discrepancies from the SQL standard. Frequently you don't realize
> until you port which nonstandard features you were depending on.
>
> My guess is that a PG -> Oracle port would be much less painful than
> a MySQL -> Oracle port, as MySQL is considerably off the mark in many
> areas of spec compliance. But you'd have to be careful in either
> scenario.
I'm anticipating application-level problems as you mention, but as long
as it is (relatively) straightforward to dump the data to Oracle. For
instance, can be done with PostgreSQL's equivalent of the "dump" to SQL
and then load that into the other DB.
Fortunately the application itself is planned to be a fairly simple one.
Thanks Tom,
Erik
--
Erik Price (zombies roam)
email: erikprice@mac.com
jabber: erikprice@jabber.org