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
已回答 25 天前
  • Thanks Subhashr, this helps.

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则