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(at)sunward(dot)org
> <mailto:ken(at)sunward(dot)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(dot)klaver(at)aklaver(dot)com