Force Group has developed the Ora2PgCopy Java utility to transfer data from Oracle to PostgreSQL. 10TB can be transferred from one database to another in just one day. Without using the utility, this process would take 100 hours or more.
PostgreSQL’s capabilities, multi-threading, as well as parallel transfer of data for each individual table and special processing of data as BLOBs and CLOBs helped shorten the process, the company said.
The Ora2PgCopy utility is used during the migration process when the tables have already been created in PostgreSQL and the program code has been migrated. Ora2PgCopy can work as a module within the LUI4ORA2PG migration automation system (developed by Force Telecom for migration automation) or be used independently.
The company claims that according to test results, Ora2PgCopy works faster than other analogues, such as Ispirer (convertum), Oracle_fdw, ora2pg and Pentaho kettle.
- In 2022, Russian state-owned companies bought national database management systems (DBMS) three times more than the previous year. In 2021, Russian solutions accounted for around 60 contracts. In 2022, against the background of sanctions, their number increased to more than 200. At the same time, the cost of software solutions increased from 690 million to 2 billion rubles.
- In May of last year, Russian President Vladimir Putin signed a decree that all critical information infrastructure facilities must switch to home software and equipment. This must be done before January 1, 2025.
Author:
karina pardaeva
Source: RB
I am a professional journalist and content creator with extensive experience writing for news websites. I currently work as an author at Gadget Onus, where I specialize in covering hot news topics. My written pieces have been published on some of the biggest media outlets around the world, including The Guardian and BBC News.
