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
