We are about to merge two servers that have essentially the same data. We had an office that was outside of any high speed internet access and were manually moving files between offices for years. Now we are bringing them together and I am worried about merging the data because some people named things one way, other people named them another way. one person used an "&" and another used "and" etc etc. in some cases a file with the same name but newer modified date may not actually be the correct file needed... its a mess.
I am looking for a piece of software that will hopefully go through the folders on both sides renaming based on certain things ie if & then change to and, or if double space in the name delete one space, etc etc. Then be able to merge the directories but being able to also apply rules like if a file is going to be over written then move said file to another location, and create a log I can had to someone to be able to go through and check that the data is right.
Anyone use such a software or have any good ideas for this process?
Thanks in advance!