We need to migrate data from AS/400 (DB2/400) to AWS (MySQL)

0

We need to migrate 200G data from AS/400 (Database is DB2/400) to AWS (MySQL). Any lead please. How to do this one or anyone had done this in past.

  • We at Micro Focus do this all the time. We have tools to automate this data migration.

已提問 2 年前檢視次數 1651 次
4 個答案
0

AWS DMS does not support Db2 on AS/400 at the moment.

Look into Precisely instead which supports near real-time replication from midrange systems including AS/400: https://aws.amazon.com/about-aws/whats-new/2023/11/aws-mainframe-modernization-replication-precisely-ibm-i/

AWS
vg
已回答 6 個月前
  • is precisely connect supports bidirectional synchronization (not only changes made in DB2 will be replicated to AWS RDS, but also changes made in AWS RDS will be replicated to DB2(AS/400)?

0

At this moment, AWS DMS does not support Db2/400 as a source. There are CDC tools like Qlik Replicate that can migrate data from Db2/400 to Amazon RDS for MySQL.

You can also use an ETL tool like AWS Glue to extract, transform and load data from Db2/400 to Amazon RDS for MySQL.

AWS
vg
已回答 2 年前
0

We are also looking for solution/options to replicate DB2 database running on IBMi (aka AS400) to AWS. Please share any ideas/options/solutions which we were already implemented for this use case.

Utham
已回答 8 個月前
0

any news regarding the support Db2/400 as a source for DMS?

Andrea
已回答 6 個月前

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

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

回答問題指南