Duration to Migrate zOS DB2 to RDS PostgreSQL

0

Any rough time taken to migrate zOS DB2 to RDS PostgreSQL? DB2 db size is 50GB, this is only for the actual data migration.
Assuming JDBC connectivity is setup, schema converted, all codes are converted.

1 個回答
1

For migrating a 50GB z/OS DB2 database to Amazon RDS for PostgreSQL using AWS Database Migration Service (AWS DMS), and assuming all necessary preparations are done, the approximate time taken would be:

Initial Load: 2-4 hours

Ongoing Replication: Minimal

Data Validation and Cutover: 1-2 hours

Total time: Approximately 4-8 hours, assuming no major issues or complexities.

It's important to note that this estimate assumes a relatively straightforward migration scenario with a moderately complex database schema and no significant data or schema transformations required during the migration process.

If you encounter any challenges or complexities, such as large numbers of tables or indexes, complex data transformations, or performance bottlenecks, the migration time could potentially increase.

Additionally, it's recommended to perform thorough testing and validation in a non-production environment before executing the actual migration to ensure a smooth and successful transition to the RDS PostgreSQL environment.

AWS
已回答 1 個月前
  • Thanks Subhashr, this helps.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南