Question

1
Replies
392
Views
gordn Member since 2010 10 posts
PEGA
Posted: September 14, 2016
Last activity: September 15, 2016
Closed

migrate Database from DB2 to Oracle

Hi, i want to migrate my database from DB2 to Oracle, has anyone had any experience in using SQL / DB tools to copy the work item tables from DB2 to Oracle.

Using the migration tools i can get the data across but the blob cannot be referenced this shows crc  errors when trying to open it. I was wondering if anyone had done something similar, otherwise our option will be to use pega to read each case in from DB2 and then write the case to the oracle db. however as there are many case items this will take a long time and we would prefer to use DB tools if possible

Case Management Data Integration
Moderation Team has archived post
Share this page LinkedIn