Postgres Pro
Downloads
Home   >   mailing lists

postgresql and oracle, compatibility assessment - Mailing list pgsql-hackers

From Martin Matusiak
Subject postgresql and oracle, compatibility assessment
Date
Msg-id 003c01c2d694$632ca7d0$ea80f181@frasier
Whole thread Raw
Responses Re: postgresql and oracle, compatibility assessment  (Hannu Krosing <hannu@tm.ee>)
Re: postgresql and oracle, compatibility assessment  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view
Greetings,
 
I am doing a project for college developing a java system utilizing a RDBMS. The choice is between PostgreSQL and Oracle and I'm wondering exactly how impossible would it be to make it compatible with both. Postgre is said to be completely ANSI SQL complaint, is it feasible to imagine one could run dumps from Postgre into Oracle and vice versa? Alternatively, run separate queries on both to set the structure and relations, then transfer only data?
 
PostgreSQL 7.3
Oracle 8.x 
 
 
Best regards,
 
Martin Matusiak

pgsql-hackers by date:

Previous
From: Christoph Haller
Date:
Subject: IpcSemaphoreKill: ...) failed: Invalid argument
Next
From: Hannu Krosing
Date:
Subject: Re: postgresql and oracle, compatibility assessment