Discussion 1 Replies 259 Views × Close popover Chandra Andhe (chandu231) CA View Profile Send Message chandu231 Member since 2014 1 post Posted: April 30, 2016 Last activity: June 30, 2016 Posted: 30 Apr 2016 8:52 EDT Last activity: 30 Jun 2016 20:51 EDT Closed Oracle to DB2 data migration Hi All, We are trying to move data from an Oracle Database to DB2 for an existing application. We would like to copy over the Cases and Custom data. Custom data migration is easy since it does not have any BLOB fields. THe issues is when the BLOB fields come into play. These are the couple of questions I have: 1) Can I copy all the tables using a .sql insert script from Oracle and run it on DB2? Will this help me retrieve all the Old Cases? 2) Is there any difference in the content of the BLOB field when it is saved in Oracle vs DB2? 3) Any better tools that can aid in the migration of the data. Any help is greatly appreciated. Thanks, Chandu Data Integration Share × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion. Posted: 4 years ago Posted: 30 Jun 2016 20:51 EDT × Close popover Abhijith Kolanakuduru (Abhijith_CLSA_v62) IP Australia Pega Certified Lead System Architect IP Australia AU View Profile Send Message Abhijith_CLSA_v62 IP Australia replied to chandu231 Did you try "Package Work" wizard. It's in Application->Distribution It'll have something like this.