Re: Porting from ORACLE to PostgSQL

>> Bye, Chris.
>  Thank you, but nothing work.
> 1. The orafce from www.pgfoundry.org doesn't pass the make step, is
> looking for some files  that doesn't exist, see below:
>    orafce : make
>    Makefile:16: ../../src/Makefile.global: No such file or directory
>    Makefile:17: /contrib/contrib-global.mk: No such file or directory
>    make: *** No rule to make target `/contrib/contrib-global.mk'.  Stop.


It is designed to be built from the postgresql source tree. If you have
a postgresql source tree put the orafce directory in contrib and try again.

Sincerely,

Joshua D. Drake

>
> 2. ora2pg, looks like something that extract DB schemes from a running
> oracle DB, but I have not ORACLE running. I just have old ORACLE/SQL
> sources that I need parser to SQL or PostgSQL.
>
> 3. About the ambitious project "protopg", I success to compile this
> projects but the parser fall. The parse have a problem with a word
> "CONSTRAINT", see below:
>    protopg-20060905 : ./ora_parser < tes.sql
>    -- syntax error, unexpected "CONSTRAINT", expecting ORA_ID on line 6 --
>
>    -- BEGIN OF UNRECOGNIZED STATEMENT
>    CREATE TABLE v5templates . cmt_items ( item_id NUMBER ( 7 ) ,
> template_id NUMBER ( 7 ) , page_title VARCHAR2 (     100 ) , CONSTRAINT
> pk_cmt PRIMARY KEY ( item_id ) ) ;
>    -- END OF UNRECOGNIZED STATEMENT
>
> I will try debug it, or maybe send a mail to the developer/contacts.
>
> Any way, thank very much, Gustavo
>


--

    === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
    Providing the most comprehensive  PostgreSQL solutions since 1997
              http://www.commandprompt.com/