The objective here is to validate the D6 db and get its fields back to pristine condition.
The plan is to:
- Build a clean D6 and clone it.
- Restore Dec 2010 db to the clone and check the differences between it and the clean D6.
- Make another clone of the clean D6 and restore the latest backup to it – taken especially
- Run the ‘repair SQL script’ on that and validate against line 2.
- If really happy, take a back up of that and restore to Production on UK2.
Then use a locally restored copy of UK2 Production to build a migration script in SQL for D6 to D7 so that the images are not totally lost.