How to update the Type of the EPMDocument

[adev-2]

Hi,

I am working in data migration  but mistakenly I have loaded data in wt.epm.EPMDocument but I want to load data in wt.epm.EPMDocument|com.xxxxxx.DefaultEPMDocument data type can any one please tell me which table values I need to updated

select epmdocument.ida2a2, controlbranch.ida2a2, epmdocumentmaster.documentnumber, wttypedefinitionmaster.inthid, wttypedefinitionmaster.ida2a2 from wttypedefinitionmaster, epmdocumentmaster, epmdocument, controlbranch

where epmdocumentmaster.ida2a2 = epmdocument.ida3masterreference and controlbranch.ida3b5 = wttypedefinitionmaster.ida2a2

and epmdocument.branchida2typedefinitionrefe = controlbranch.ida2a2 and  epmdocumentmaster.documentnumber = 'xxxxxx.PRT';

I have updated epmdocument.branchida2typedefinitionrefe but it did not work

[BenPerry]

Ankit Dev‌,

Have you reviewed these 2 articles yet?

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS7287

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS52368

The article states you need to update both branchIdA2typeDefinitionRefe and idA2typeDefinitionReference values.

[adev-2]

Thank you Ben,

This is really very helpful I am able to change the type of object