Re: Oracle to PostgreSQL Tool

New version applied to current CVS tree.  Thanks.

> Hi all,
>
> Here the latest version and first working release of Ora2Pg a tool to export
> Oracle database to PostgreSQL.
>
>     It currently dump the database schema (tables, views, sequences,
>     indexes, grants), with primary, unique and foreign keys into PostgreSQL
>     syntax without editing the SQL code generated. You can dump only a
>     particular schema from the Oracle database.
>
>     Functions, procedures and triggers with SQL or PLSQL code generated must
>     be reviewed to match the PostgreSQL syntax. Some usefull recommandation
>     on porting Oracle to PostgreSQL can be found at
> http://techdocs.postgresql.org/
>     under the "Converting from other Databases to PostgreSQL" Oracle part. I
> just
>     notice one thing more is that the trunc() function in Oracle is the same for
> number
>     or date so be carefull when porting to PostgreSQL to use trunc() for number
> and
>     date_trunc() for date.
>
> I will add more precision in type NUMBER conversion based on length to match
> as closest as possible all rich PostgreSQL numerics type. But it seems not to be
>
> urgent as it seems that Oracle DBAs only create number with length 22 (default)
> Space seems not to be their problem...
>
> The following need help :
>
>         - SQL query converter.
>         - SQL/PLSQL code converter.
>         - Extracting/converting data for loading into PostgreSQL.
>
> By this I mean replacing Oracle function by PostgreSQL one's into the SQL code
> and reformat some type to match PostgreSQL syntax.
>
> Extract data as text seem not be possible with Oracle so the only way is to
> select data from oracle and convert them on the fly by a online program.
>
> Latest version (1.3) will be available under /contrib soon (thanks to Bruce)
> but you can find it now at http://www.samse.fr/GPL/ora2pg/
>
> Regards
>
> Gilles DAROLD
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026