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