红联Linux门户
Linux帮助

ora2pg 12.1发布,Oracle转PostgreSQL工具

发布时间:2014-01-29 09:19:59来源:红联作者:empast
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.

项目主页:http://ora2pg.darold.net/

下载地址:http://sourceforge.net/projects/ora2pg/

来自:开源中国社区
文章评论

共有 0 条评论