| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | Martin Matusiak <db(at)juventuz(dot)net> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: postgresql and oracle, compatibility assessment |
| Date: | 2003-02-17 15:03:34 |
| Message-ID: | 1045494214.1700.2.camel@fuji.krosing.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-02-17 15:04:05 | Re: Questions about indexes? |
| Previous Message | Martin Matusiak | 2003-02-17 14:53:51 | postgresql and oracle, compatibility assessment |