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