Would it be possible to create some sort of transparent API based on ODBC to be used with PostgreSQL and Oracle? I know there exists a JDBC - ODBC bridge for java.
Martin ----- Original Message ----- From: "Hannu Krosing" <[EMAIL PROTECTED]> To: "Martin Matusiak" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, February 17, 2003 4:03 PM Subject: Re: [HACKERS] postgresql and oracle, compatibility assessment > Martin Matusiak kirjutas E, 17.02.2003 kell 16:53: > > 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, > > PostgreSQL is *much* more ANSI comliant than Oracle. > > > is it feasible to imagine one could run dumps from Postgre into Oracle > > and vice versa? > > Not all data types are named the same (Oracles varchar is varchar2, > etc.) > > > Alternatively, run separate queries on both to set the structure and > > relations, then transfer only data? > > Much more likely to succeed. > > You may be interested in OpenACS ( http://openacs.org/ ) project, which > runs on both Oracle and PostgreSQL. > > --------- > Hannu > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > > > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
