ora2pg 9.2 发布，该版本包含大量的代码改进，特别是大小写处理方面的，另外支持到处用户自定义组合类型。
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.
主页：http://pgfoundry.org/projects/ora2pg/
下载：http://pgfoundry.org/frs/?group_id=1000312
来自:开源中国社区
