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

[Adrian Klaver]

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=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 > 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.kla...@aklaver.com


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

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

[Ken Winter]

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=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.

~ Thanks, Ken

On Wed, Feb 24, 2016 at 10:52 PM, Ken Winter  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
>
>
>

[GENERAL] Generate PG schemas from the Oracle Data Modeler tool?

[Ken Winter]

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