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