This website uses cookies.
Cookies are small text files that allow us to create the best browsing experience for you on our site. Some cookies are necessary for our website and services to function properly. Others are optional.
You can accept all cookies, consent to only necessary cookies, or manage optional cookies. Without a selection, our default cookie settings will apply and expire in one year. You can change your preferences by clicking ‘Manage Cookies’ in the footer. To understand how we use cookies, please read our cookies policy.
This website uses cookies.
Currently, cookies are disabled in your browser. Please enable them and reload the page to continue.
To understand how we use cookies, please read our cookies policy.
Always On
These cookies are necessary for our website to function and cannot be switched off. They do not store any personally identifiable information.
These cookies store the user’s preferred language, region, currency, or color theme and enable the website to provide enhanced personalization.
These cookies are used to collect valuable information on how our website is being used. This information can help identify issues and figure out what needs to be improved on the site, as well as what content is useful to site visitors.
Third-party advertising and social media cookies are used to track users across multiple websites in order to allow publishers to display relevant and engaging advertisements. If you do not allow these cookies, you will experience less targeted advertising.
*Your consent will expire in one year.
Share your requirements and we'll get back to you with how we can help.
Based in Japan, our client is a global leader in human resource services providing flexible HR solutions tailored to the evolving labor market.
HR
A global leader in HR services, on its digital transformation journey, sought to adopt cloud-native solutions to enhance operational efficiency. To align with their data and cloud strategy, they aimed to modernize their on-premises IBM Db2 databases to a fully managed cloud service with zero downtime. AWS was chosen for its robust infrastructure, security, compliance, and seamless migration capabilities.
A significant challenge faced by the client is the high cost associated with IBM Db2 licenses. Additionally, with IBM planning to discontinue support for Db2 versions up to 10.5 within a year, there were both financial and operational implications that needed to be addressed to ensure uninterrupted database functionality.
We proposed migrating the IBM Db2 database to AWS RDS for PostgreSQL, leveraging PostgreSQL’s robust features and cost-effectiveness to address the client’s needs.
Our objective was to successfully migrate approximately 500 GB of data across 600 tables from IBM Db2 (version 9.7) to AWS RDS for PostgreSQL (version 16.2) while ensuring:
The migration of IBM Db2 9.7 to AWS RDS for PostgreSQL 16.2 was successfully executed, ensuring full schema and data compatibility. The process required resolving encoding mismatches, modifying triggers manually, and validating the migrated data effectively. From this experience, several learnings emerged that would optimize future migrations:
A significant challenge faced by the client is the high cost associated with IBM Db2 licenses. Additionally, with IBM planning to discontinue support for Db2 versions up to 10.5 within a year, there were both financial and operational implications that needed to be addressed to ensure uninterrupted database functionality.
We proposed migrating the IBM Db2 database to AWS RDS for PostgreSQL, leveraging PostgreSQL’s robust features and cost-effectiveness to address the client’s needs.
Our objective was to successfully migrate approximately 500 GB of data across 600 tables from IBM Db2 (version 9.7) to AWS RDS for PostgreSQL (version 16.2) while ensuring:
The migration of IBM Db2 9.7 to AWS RDS for PostgreSQL 16.2 was successfully executed, ensuring full schema and data compatibility. The process required resolving encoding mismatches, modifying triggers manually, and validating the migrated data effectively. From this experience, several learnings emerged that would optimize future migrations: