Oracle向PostgreSQL迁移工具 ora2p

openkk 9年前

Ora2Pg是一个免费工具用于将一个Oracle数据迁移至PostgreSQL兼容的数据库结构。它连到你的Oracle数据,自动扫描并抽出结构和数据库,然后生成可以在PostgreSQL数据库中执行的SQL脚本。
Oracle向PostgreSQL迁移工具 ora2p

功能包括:

        - Export full database schema (tables, views, sequences, indexes), with unique, primary, foreign key and check constraints.          - Export grants/privileges for users and groups.          - Export a table selection (by specifying the table names).          - Export Oracle schema to a PostgreSQL 7.3+ schema.          - Export predefined functions, triggers, procedures, packages and package bodies.   - Export range and list Oracle partition.          - Export full datas or following a WHERE clause.   - Full support of Oracle BLOB object as PG BYTEA.          - Export Oracle views as PG tables.   - Export Oracle user defined types.          - Provide basic help for converting PLSQL code to PLPGSQL (still needs manual work).   - Works on any plateform.

项目主页:http://www.open-open.com/lib/view/home/1339988065143