Ora2pg可以用来将Oracle数据库转换成PostgreSQL,主要功能:
- 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.