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 18.2 发布,Oracle和MySQL 转 PostgreSQL 工具
这个版本修正了过去六个月中报告的各种问题,另外还添加了若干新特性和配置选项:   - Add translation of SUBSTRB into substr.   - Allow use of array in MODIFY_TYPE to export Oracle user defined &

发布于 2017-10-08 14:33:21 | 111 次阅读


Copyright © 2007-2017 PHPERZ.COM All Rights Reserved   冀ICP备14009818号  版权声明  广告服务