Generate PG schemas from the Oracle Data Modeler tool?

Поиск
Список
Период
Сортировка
От Ken Winter
Тема Generate PG schemas from the Oracle Data Modeler tool?
Дата
Msg-id CABV8-AaAJoDWgMuZQxf2Z2FL906N39sNz=ierS1U=_4dvVzbbw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Generate PG schemas from the Oracle Data Modeler tool?
Список pgsql-general
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


В списке pgsql-general по дате отправления: