Question
1
Replies
91
Views
TCS
Posted: April 23, 2019
Last activity: April 23, 2019
Closed
db2 to postgres
we are doing a PoC wherein we want to migrate from DB2(zOS) to postgres.
went over all the articles and came across a Pega Data Mover utility. would like tp understand if this Pega tool can be utilised to perform the following:
- read table definitions from source database and apply the definition in destination database
- Once DDLs are applied in destination database, data to be copied.
is there any help file for this tool. has any customer done this earlier?
we are on Pega 7.3.1 and we intend to only perform db2 to postgres migration.
***Edited by Moderator: Pallavi to update platform capability tags***
As far as I know, this tool has never be intended for external usage. It was used internally more than 3-4 years ago. You probably better off using some 3rd party tools, e.g., https://www.ispirer.com/products/db2-zos-to-postgresql-migration. We used AWS DMS to migrate certain Oracle client databases to Postresql: https://docs.aws.amazon.com/dms/latest/sbs/CHAP_RDSOracle2PostgreSQL.html