- Newest
- Most votes
- Most comments
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.
Relevant content
- Accepted Answerasked 23 days ago
- asked 7 months ago
- asked 3 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 years ago
Thanks Subhashr, this helps.