Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Pratheep Kumar M S (PRATHEEP KUMAR MS)
TCS

TCS
GB
PRATHEEP KUMAR MS Member since 2011 22 posts
TCS
Posted: Apr 23, 2019
Last activity: Apr 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***

To see attachments, please log in.
Pega Platform
Data Integration

Posted: 5 years ago
Posted: 23 Apr 2019 18:37 EDT
Kevin Zheng (KevinZheng_GCS)
PEGA
Director, Technical Support
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

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice