Skip to main content
Log in

Database Migration from ORACLE to PostgreSQL

  • Published:
Programming and Computer Software Aims and scope Submit manuscript

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Fig. 1.
Fig. 2.
Fig. 3.
Fig. 4.
Fig. 5.

Similar content being viewed by others

Explore related subjects

Discover the latest articles, news and stories from top researchers in related subjects.

REFERENCES

  1. Sinitsky, V., Extreme migration to PostgreSQL: without stopping, losses and testing. https://habr.com/ru/company/yoomoney/blog/326998/.

  2. 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.

  3. 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.

  4. PostgreSQL and Postgres Pro documentation. https://postgrespro.ru/docs/.

  5. 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.

  6. Object-relational mapping. https://en.wikipedia.org/wiki/Object%E2%80%93relational_mapping.

Download references

Author information

Authors and Affiliations

Authors

Corresponding authors

Correspondence to E. A. Kurako or V. L. Orlov.

Additional information

Translated by V. Arutyunyan

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

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

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1134/S0361768823050055

Keywords:

Navigation