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(at)postgresql(dot)org
>

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