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.





Similar content being viewed by others
Explore related subjects
Discover the latest articles, news and stories from top researchers in related subjects.REFERENCES
Sinitsky, V., Extreme migration to PostgreSQL: without stopping, losses and testing. https://habr.com/ru/company/yoomoney/blog/326998/.
Kurako, E.A., Translator of Oracle-PostgreSQL structures (OracleToPostgres_Scheme). Certificate of state registration of computer program No. 2019614473, Russian Federation, Moscow, April 5, 2019.
Kurako, E.A., Oracle-PostgreSQL data transfer (Oracle-ToPostgres_Data). Certificate of state registration of computer program No. 2019614472, Russian Federation, Moscow, April 5, 2019.
PostgreSQL and Postgres Pro documentation. https://postgrespro.ru/docs/.
Kurako, E.A. and Noga, N.L., Oracle-PostgreSQL stored procedure preconverter (OracleToPostgres_Procedure), Certificate of state registration of computer program No. 2019614616, Russian Federation, Moscow, April 9, 2019.
Object-relational mapping. https://en.wikipedia.org/wiki/Object%E2%80%93relational_mapping.
Author information
Authors and Affiliations
Corresponding authors
Additional information
Translated by V. Arutyunyan
Rights and permissions
About this article
Cite this article
Kurako, E.A., Orlov, V.L. Database Migration from ORACLE to PostgreSQL. Program Comput Soft 49, 455–463 (2023). https://doi.org/10.1134/S0361768823050055
Received:
Revised:
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1134/S0361768823050055