moving a sub agreement from one Master Agreement to another MasterAgreement

Hi Sourcing Experts,

We have created a Sub Agreement under a Master Agreement, later, we found that it should be created under another Master Agreement.

For this, we thought to move this Sub Agreement to actual Master Agreement instead of creating new one.

To do so, we tried a csv file import pointing to actual Master Agreement, but import is failing with the error "This Sub Agreement is pointing to another Master Agreement"

Alternatively, we did DB update like updating this Sub Agreement's Parent_Object_ID with actual Master Agreement object id. this is working fine, now the sub agreement is under correct Master.

Instead of DB approach, Is there any better approach to move Sub agreement from one Master Agreement to another MA ?

Please share your ideas, appreciate your help.

Thanks

Krish