Postgres Pro
Downloads
Home   >   mailing lists

Generate PG schemas from the Oracle Data Modeler tool? - Mailing list pgsql-general

From Ken Winter
Subject Generate PG schemas from the Oracle Data Modeler tool?
Date
Msg-id CABV8-AaAJoDWgMuZQxf2Z2FL906N39sNz=ierS1U=_4dvVzbbw@mail.gmail.com
Whole thread Raw
Responses Re: Generate PG schemas from the Oracle Data Modeler tool?
List pgsql-general
Tree view
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


pgsql-general by date:

Previous
From: Maxim Boguk
Date:
Subject: 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?
Next
From: Karsten Hilbert
Date:
Subject: Re: check constraint problem during COPY while pg_upgrade-ing