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.
IT Group Inc. Empowers Finance and Accounting Professionals at the 79th PICPA Annual National Convention
IT Group Inc. Empowers Finance and Accounting Professionals at the 79th PICPA Annual National ...
IT Group, Inc. and BlackLine Forge Strategic Partnership as Gold Sponsor at the 56th FINEX Summit
IT Group, Inc. and BlackLine Forge Strategic Partnership as Gold Sponsor at the 56th FINEX Summit ...
IT Group Inc. Sponsors IT-BPM Summit
IT Group, Inc. Sponsors IT-BPM Summit: Empowering Businesses Through Streamlined Active Directory ...