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/