I want to get this sorted, but it feels to me like this would require an enormous transaction which would totally lock up the database.
Instead lets just get some basics here first:
On first failure, abort and print a message saying it was only partially applied asking users to re-run the remap.
@supermathie does that work for you? @zogstrip do you mind if I reassign this to @Osama ?