Abstract

Methods of data transfer from the Oracle environment to the PostgreSQL environment with stage-by-stage organization of actions and determination of the sequence of migration are considered. The main directions for the transformation of the structure of databases, data formats and executed objects are identified. Methods for converting stored procedures and triggers written in procedural languages (PL/SQL and PL/pgSQL) are specified. Software change on nodes directly connected (associated) with the database server and minimization of downtimes during migration are considered, which allows the transfer to be performed for geographically distributed and round-the-clock functioning objects. Examples of changing the speed of query execution before and after migration are given for systems of various types.

中文翻译：

---

数据库从 ORACLE 迁移到 PostgreSQL

摘要

考虑了从Oracle环境到PostgreSQL环境的数据传输方法，分阶段组织动作并确定迁移顺序。确定了数据库结构、数据格式和执行对象转变的主要方向。指定了转换用过程语言（PL/SQL 和 PL/pgSQL）编写的存储过程和触发器的方法。考虑了与数据库服务器直接连接（关联）的节点上的软件更改以及迁移期间停机时间的最小化，这允许对地理上分布的和全天候运行的对象执行传输。针对各种类型的系统给出了在迁移之前和之后改变查询执行速度的示例。