We currently have an object that for many different reasons will be deprecated. We want to move the records to a new object, but also want to retain the approval history. Has anyone done this before?
I have tried to SOQL Approval object, and see if I can re-parent records - but this object was empty when using SOQL from the developer console. Then with some searching on here, I found that the approval history is stored in another object, ProcessInstance and I did manage to SOQL for the records I want to migrate. Unfortunately I was unable to edit the TargetObjectId to migrate the records.
Has anyone done this before, or it is impossible?