• Bruce Momjian's avatar
    Here the latest version and first working release of Ora2Pg a tool to export · 2e2d17ed
    Bruce Momjian authored
    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...
    
    Gilles DAROLD
    2e2d17ed
TODO 276 Bytes