Novermber 11 – 12 | Krasnoyarsk, Reshetnev University

PgConf.Siberia 2019

What is PgConf.Siberia 2019?

Selected talks

Иван Чувашов

ООО СИГМА

ведущий разработчик-эксперт, архитектор баз данных

Talk

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.

Slides

Anton Doroshkevich

InfoSoft

Chief Information Officer

Talk

Features switching 1C replica and back

1C is not able to work out of the box with several DB instances at once, so switching "out of the box" of 1C to a replica in case of failure of the wizard and back does not exist. In my report, I want to talk about approaches to such switching and several options for its implementation.