Imagine a large SAN with one hundred thousand files in a unorganized directory structure.
The files will be moved to a new SAN with an organised directory structure. Some files will be renamed when they are moved. Also many files have references, eg Excel Spreadsheets are interlinked and these will break after the move.
We need to keep a map of From and To file paths encase we need to refer back to the archive, eg to fix a broken link.
I've done research to see if there was anything on the market but no luck. Hence I've begun writing an application that allows users to drag and drop files and records to a SQL dB:
I'm not 100% sure on this approach. Does anyone know if there is a better way to do this? Is there anything in Windows?
We were thinking of scanning the old and new directories and doing a map that way. Unfortunately this wont fly as the file name could change and the Create/Modified etc Dates will be today for the moved files.
We were thinking of having some unique identifier in each file but that idea never got traction as where would you store the unique identifier for different file types?
Possibly a AutoHotKey script?