Performance Improvements in EDB Migration Toolkit 52.0.3
Performance Improvements in EDB Migration Toolkit 52.0.3
August 2019
From the older version of EDB Postgres Migration Toolkit (MTK), it would take a while to finish the database migration because we can’t increase the value of fetch-Size option. Otherwise, it will result in Out of Memory error.
ITG, in partnership with EDB through Postgres Migration Toolkit, supported one of the biggest banks in the country to eliminate the risk of migration and improve the total migration process.
The ease of migration from legacy to open-source database helps the customer to adopt and migrate in a very fast-paced work environment.
The EDB Postgres Migration Toolkit (MTK) is a powerful command-line tool that offers granular control of the process of migrating database objects and data from other database management systems to EDB Postgres Advanced Server and PostgreSQL.
MTK supports migration of the following databases:
- Oracle® Database
- SQL Server
- Sybase
- PostgreSQL
MTK supports migration of the following databases:
- Oracle® Database
- SQL Server
- Sybase
- PostgreSQL
Migrating data from Oracle to Advanced Server using fetch-Size option:
Starting this release, the overall data migration time from Oracle to Advanced Server improved substantially while fixing the fetch-Size option related issue
Migration Process:
Migrating table structure only:
Migrating data using -fetchSize option (with different values):
Fast Migration Process
Using JDBC’s default fetch-Size (Value for fetch-Size option is not specified):Â
While running MTK, if no value for fetch-Size is specified, then MTK uses default JDBC fetch-Size (10, in case of Oracle JDBC) and migrating hundred thousand rows takes around 40 minutes.
Improve Performance through fetch-Size option
After using the appropriate fetch-Size option, the performance has improved by 98% on average. Note: You may not see further significant improvement post a certain fetch-Size value.
Next-Gen IT, Powered by Open Source – Highlights from Red Hat Day 2025 with ITG & Elastic
Next-Gen IT, Powered by Open Source – Highlights from Red Hat Day 2025 with ITG & Elastic April ...
Empowering Financial Success: ITG and NetSuite Drive CAS Compliance in Davao
Empowering Financial Success: ITG and NetSuite Drive CAS Compliance in Davao April 8, 2025 | Event ...
ManageEngine CyberCon Philippines 2025: A Resounding Success in Manila and Cebu
ManageEngine CyberCon Philippines 2025: A Resounding Success in Manila and Cebu March 27, 2025 | ...