Oracle 迁移至 PostgreSQL 工具,ora2pg 9.0 发布
jopen 12年前
<p><span class="truncate_more"><a href="/misc/goto?guid=4958189492565884955" target="_blank">ora2pg </a>9.0 发布,这是一个全新的版本,主要是完全支持 Windows 系统,提供新的源码树和 Makefile.PL 构建脚本。同时修复了长期存在的 CLOB 和 BLOB 导出问题,更改了 timestamp 和 table/column 导出的问题。</span></p> <p>Ora2pg可以用来将Oracle数据库转换成PostgreSQL,主要功能: </p> <p>- Export full database schema (tables, views, sequences, indexes), with unique, primary, foreign key and check constraints.<br /> - Export grants/privileges for users and groups.<br /> - Export a table selection (by specifying the table names).<br /> - Export Oracle schema to a PostgreSQL 7.3+ schema.<br /> - Export predefined functions, triggers, procedures, packages and package bodies.<br /> - Export range and list Oracle partition.<br /> - Export full datas or following a WHERE clause.<br /> - Full support of Oracle BLOB object as PG BYTEA.<br /> - Export Oracle views as PG tables.<br /> - Export Oracle user defined types.<br /> - Provide basic help for converting PLSQL code to PLPGSQL (still needs manual work).<br /> - Works on any plateform.</p>