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
Virtusa IT Consulting
AE
There are migrateSystem.properties and migrate.bat that can be used to try this usecase where you can specify both source and target DB system details. You have mentioned that you already tried this did you use full JDBC url to connect to DB2 with custom properties as below?
fullyMaterializeLobData=true;fullyMaterializeInputStreams=true;progressiveStreaming=2;useJDBC4ColumnNameAndLabelSemantics=2;