ora2pg 12.1 发布,此版本是个小版本,主要是修复了一些 bug,添加一个新的配置指导;添加了 INDEXES_SUFFIX,为了给索引名字添加后缀。
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.
ora2pg 的详细介绍:请点这里
ora2pg 的下载地址:请点这里
相关阅读:
PostgreSQL删除表中重复数据行 http://www.linuxidc.com/Linux/2013-07/87780.htm
PostgreSQL数据库连接池PgBouncer的搭建 http://www.linuxidc.com/Linux/2013-06/85928.htm
Windows平台编译 PostgreSQL http://www.linuxidc.com/Linux/2013-05/85114.htm
PostgreSQL备份心得笔记 http://www.linuxidc.com/Linux/2013-04/82812.htm