Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxx
<mailto:ken@xxxxxxxxxxx>> 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@xxxxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux