title

text

Anton Nemtsev
Anton Nemtsev Netrika LLC
12:00 04 April
22 min

Case of moving a DBMS with business logic to Postgres PRO

I will share the experience of migration project of an information system from a Microsoft SQL Server DBMS to Postgres PRO. The owner of the DBMS is Rosagroleasing JSC.

The volume of the DBMS database is about 6 TB (more than 300 tables, up to 4 billion records in each). The team adapted 15 ETL packages and 131 procedures with full functionality and also partial refactoring of the source code. Systems' performance has remained the same.

Slides

Video

Other talks