Bell Integrator: Database Migration Optimization Wizard from Oracle Database to PostgreSQL

Main article: IT Service Management, ITSM

2024: Introducing the Database Migration Optimization Wizard from Oracle Database to PostgreSQL

Bell Integrator (Softline Group of Companies) on October 21, 2024 presented a development that allows you to migrate from Oracle to PostgreSQL. The Bell Integrator solution uses tested, platform-specific approaches to code migration. The DBMS Migration Optimization Wizard will allow companies to significantly speed up the migration process and minimize the risk of data and code migration errors, ensuring that the process is automated as much as possible.

In addition, the development makes it possible to migrate more than 95% of code objects. At the same time, during migration, logic is preserved in the database with the necessary minimum of transformations, the developers emphasized.

The solution works as an application in two versions - Light and Core. The first assesses the volume and variety of the system, parses the code and predicts convertibility, and also allows you to assess the complexity. The Core version provides a full cycle of code migration, transforms and formats code.

Import substitution of solutions is one of the most demanded areas of activity. According to experts, the migration process is only a matter of time. And here it is very important not to make a mistake in choosing a tool, thanks to which migration can be implemented quickly and without errors. Given that Oracle and PostgreSQL take different approaches to data storage, indexes, transaction management and query execution, this greatly complicates the conversion of code and data. And our task was to offer the market a convenient and effective tool that automates the process as much as possible and makes the transition less time-consuming and risky. Actually, we achieved this, - commented Alexander Pilshchikov, head of the Bell Integrator DBMS competence center.