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.</pre> <p><strong>項目主頁:</strong><a href="http://www.baiduhome.net/lib/view/home/1339988065143" target="_blank">http://www.baiduhome.net/lib/view/home/1339988065143</a></p>
本文由用戶 openkk 自行上傳分享,僅供網友學習交流。所有權歸原作者,若您的權利被侵害,請聯系管理員。
轉載本站原創文章,請注明出處,并保留原始鏈接、圖片水印。
本站是一個以用戶分享為主的開源技術平臺,歡迎各類分享!