Oracle向PostgreSQL迁移工具 ora2p
Ora2Pg是一个免费工具用于将一个Oracle数据迁移至PostgreSQL兼容的数据库结构。它连到你的Oracle数据,自动扫描并抽出结构和数据库,然后生成可以在PostgreSQL数据库中执行的SQL脚本。
功能包括:
- 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.
本文由用户 openkk 自行上传分享,仅供网友学习交流。所有权归原作者,若您的权利被侵害,请联系管理员。
转载本站原创文章,请注明出处,并保留原始链接、图片水印。
本站是一个以用户分享为主的开源技术平台,欢迎各类分享!