Question

1
Replies
120
Views
 Pratheep Kumar M S (PRATHEEP KUMAR MS)
TCS

TCS
GB
PRATHEEP KUMAR MS Member since 2011 22 posts
TCS
Posted: April 23, 2019
Last activity: April 23, 2019
Posted: 23 Apr 2019 8:13 EDT
Last activity: 23 Apr 2019 18:37 EDT
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:

  1. read table definitions from source database and apply the definition in destination database
  2. 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***

Pega Platform Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
Posted: 23 Apr 2019 18:37 EDT
Kevin Zheng (KevinZheng_GCS)
PEGA
Director, Software Solutions Engineering
Pegasystems Inc.
US

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