migrate from Oracle to postgresql by using ora2pg?
One of the most interesting things is the usage of PL/SQL etc. in the source database and the extent and complexity of that.
ora2pg will help convert the code. You have decisions to make: 1) Naming packages (PG does not support packages) 2) Rewriting code that calls things like DBMS_* 3) Global Temporary Tables, Views on Such Tables, etc (PG does not support) 4) Autonomous Transactions (PG can simulate with pg_background, but test thoroughly) 5) Transaction Handling (Commit/Rollback) needs to be thoroughly re-developed (Functions cannot COMMIT) 6) No IOT tables, so you will have Tables + Indexes (doubling some of our largest tables) 7) Connection Pooling Decisions 8) Completely reworking your Backup/Restore... Do you need Point In Time Recovery? (external tools) 9) Configuration Settings 10) CLOB -> Text with limitations on column size. 11) NUMBER() -> BIGINT / NUMERIC(), PK, FK, Sequences: Triggers vs. DEFAULT values 12) new tooling (psql) or IDE based? 13) Security/Ownership of Objects... 14) timestamp with timezone 15) Read this: https://wiki.postgresql.org/wiki/Don%27t_Do_This [MULTIPLE TIMES] plan to convert ONCE. Identify the problems. Throw it away, and start again. Seriously.
Обсуждают сегодня