Drupal 6 to 7 Take 2

The objective here is to validate the D6 db and get its fields back to pristine condition.

The plan is to:

  1. Build a clean D6 and clone it.
  2. Restore Dec 2010 db to the clone and check the differences between it and the clean D6.
  3. Make another clone of the clean D6 and restore the latest backup to it – taken especially
  4. Run the ‘repair SQL script’ on that and validate against line 2.
  5. 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.