Our main production site built up over seven years starting with Moodle 1.4 contains by now 124573 resources in over 5000 courses. Many of those resources are of the kind link to clusters of interlinked local course files, for example, (1) a Web page resource that links to a hot potatoes self-test that in turn links to sound files and/or pictures, or (2) a Link to a file (or website) resource that links to a miniwebsite with lots of pictures and interlinked pages, etc.
From what I have read and seen, the new file system in Moodle 2+ will break those resources. In the case of example 1 the web page will still link to the hotpot but the sound and pictures will be lost (and I haven't even figured out yet how to repair that, probably edit the hotpot to repace local links with direct links to the files in the Legacy course files. In the case of example two the index file of the site will still be linked but all the local links are broken. The solution suggested in the forums is to replace the File resource with a URL resource linking to the Index file.
Now, to avoid having to go through 5000+ courses fixing all these resources one by one, I wonder if anyone has any suggestions as to how I could resolve this (to me rather stressful) problem? I don't suppose there is a trick to turn all File resources into URL resources, or would that cause more problems than it solves?