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.

gefragt vor 2 Jahren1452 Aufrufe
4 Antworten
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
beantwortet vor 3 Monaten
  • 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
beantwortet vor 2 Jahren
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
beantwortet vor 5 Monaten
0

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

Andrea
beantwortet vor 3 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen