Anatoly Anfinogenov
Anatoly Anfinogenov АО "ВНИИЖТ"
15:00 05 February
45 мин

How I stopped worrying and migrated more than 150 PL/SQL procedures of over 60K lines of code into Postgres

I will share our experience of migrating a server application for Russian railways from Oracle 11g Standard Edition to vanilla PostgreSQL 11.5.
At the time of migration, the database contained about 200 stored procedures of over 60000 lines of Oracle PL/SQL code (which has been developed since 2006, that is, for more than 12 years), about 250 tables, and 50GB of data.
Starting with a prologue, we'll describe our adventures along the migration process, as well as pleasant and unpleasant surprises we encountered, and finally get to an epilogue and a happy end. The story is told on behalf of an Oracle user exploring Postgres.



Другие доклады

  • Christopher Travers
    Christopher Travers DeliveryHero SE
    45 мин

    Introducing Bagger: Massive Application Log Management on PostgreSQL

    This talk discusses the open source components we use at Adjust to manage a massive number (5+PB) of application log messages on PostgreSQL in a massively multi-parallel way. It provides both a use case for PostgreSQL in a big data (high volume/velocity/variety) environment, and can be used to show the power of PostgreSQL with JSONB, GIN, and more.

    This talk covers the capabilities of the components in depth, sufficient to inspire similar solutions.

  • Иван Чувашов
    Иван Чувашов ООО Calltouch
    22 мин

    Migrating data from Oracle to PostgreSQL using the Pentaho tool

    When migrating data from one DBMS to another, the question arises: choose a third-party tool or to program the migration yourself? Companies, trying to grow competencies within themselves, choose the second option. And they come across the "invention of their own bicycles". However, the market has powerful free data migration tools. One such tool is Pentaho Data Integration, part of the Pentaho Community Edition. The report will discuss the use of this package for data migration between Oracle and PostgreSQL. Particular attention will be paid to the problems with using this tool, and to the tasks of testing for the completeness and integrity of migrated data.

    Small video illustration:

  • Alexander Nikitin
    Alexander Nikitin ЗАО ЦФТ
    22 мин

    Migration database Zabbix from Oracle to PostgreSQL

    In the report I will talk about how Zabbix appeared in our company, how we lived with Oracle, why we decided to switch to PostgreSQL, what problems we had during the transition, and what software seemed like a good choice for working with PostgreSQL.

  • Kamil Islamov
    Kamil Islamov Stickeroid Ai
    22 мин

    Sequences used for business-logic implementation

    Examples of Sequences' opportunities implementations for developing business-logic powered by stored functions.