Re: Oracle to PostgreSQL

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: gilles(at)darold(dot)net, Gilles DAROLD <gilles(at)darold(dot)net>
Cc: pgsql-general(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Oracle to PostgreSQL
Date: 2001-04-17 13:59:16
Message-ID: 987515956.3adc4c3422a2b@webmail.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

Quoting Gilles DAROLD <gilles(at)darold(dot)net>:

snip

> So my question: Is someone here have worked on tools to export Oracle
> database
> complex schema to PostgreSQL. If then can you send them to me as I can
> construct
> a generic Oracle to PostgreSQL converter. My knowledge in Oracle is very
> poor,
> I just know about PostgreSQL but I thinks it's more the goal of
> PostgreSQL
> now that 7.1 is out than migrating from mySQL. So this should be a great
> tool.

In the source under contrib/retep there's a few Java classes that import/export
into xml. Those classes were originally tested under Oracle 8i and PostgreSQL
7.1beta. They may help.

Peter

--
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-17 14:06:04 Re: local security
Previous Message Peter T Mount 2001-04-17 13:57:12 Re: JDBC error in 7.0.3

Browse pgsql-jdbc by date

  From Date Subject
Next Message Peter T Mount 2001-04-17 15:17:30 Re: jdbc driver Multiple Resultsets
Previous Message Peter T Mount 2001-04-17 13:57:12 Re: JDBC error in 7.0.3