Generate PG schemas from the Oracle Data Modeler tool?

From: Ken Winter <ken(at)sunward(dot)org>
To: PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Generate PG schemas from the Oracle Data Modeler tool?
Date: 2016-02-25 03:52:49
Message-ID: CABV8-AaAJoDWgMuZQxf2Z2FL906N39sNz=ierS1U=_4dvVzbbw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The best affordable (in this case, free) data modeling tool that I have
found is the "Oracle SQL Developer Data Modeler" (
http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html).

The best DBMS (free or otherwise) that I have found is PostgreSQL.

So of course it would be great to be able to connect the Oracle tool to a
PG database, so one could forward- and reverse-engineer between the two.
At present, apparently the Oracle tool only natively connects with Oracle,
DB2, and SQL Server.

So I'm wondering if anybody knows of a utility or an Oracle Data Modeler
add-on that will take some dialect of SQL DDL that that tool generates and
turn it into PG-readable SQL.

I get it from the list at
https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL
that there are tools that do something more ambitious: read schemas from
actual Oracle databases and implement them as schemas in actual PG
databases. What I need is more modest than that: a tool that inputs a file
of DDL from the Oracle Data Modeler tool and outputs that DDL in PG syntax.

~ Thanks for any leads you can provide
~ Ken

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2016-02-25 09:58:51 Re: check constraint problem during COPY while pg_upgrade-ing
Previous Message Maxim Boguk 2016-02-25 02:50:11 2x Time difference between first and subsequent run of the same query on fresh established connection (on linux, with perf data included, all query data in the shared buffers) on postgresql 9.3.10. Any explanation?