Re: Generate PG schemas from the Oracle Data Modeler tool?

On 03/08/2016 08:58 AM, Ken Winter wrote:
> I have established a connection between the Oracle tool and my PG
> databases by installing the PG JDBC driver from
> https://jdbc.postgresql.org/download.html and following instructions at
> http://stackoverflow.com/questions/7592519/oracle-sql-developer-and-postgresql/22299552
> and https://www.youtube.com/watch?v=UGG_N9Mlgdw&feature=youtu.be .
>
> While the connection thus established seems solid, it delivers access to
> only part of the PG database objects.  Most weirdly, the public schema
> is invisible in the Oracle tool browser, though it displays other
> schemas I create.  For full details of this weirdness, see
> http://stackoverflow.com/questions/35809963/cant-see-postgresql-public-schema-in-oracle-sql-developer.
> Any advice from the PG world would be very welcome.

The below would seem to indicate that it can be done:

http://tabdoelhafiezkhan.blogspot.com/2014/05/reverse-engineer-postgresql-with-oracle.html

Though the links you provided seem to indicate that Oracle SQL Developer
Data Modeler behavior with Postgres is erratic.

>
> ~ Thanks, Ken
>
> On Wed, Feb 24, 2016 at 10:52 PM, Ken Winter <ken@sunward.org
> <mailto:ken@sunward.org>> wrote:
>
>     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
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com