We are usine FM 8.5 as an Electronic Medical Record system (ComChart). We have had some corruption in several database files and these have caused the system to crash. We are updating to a new version of ComChart and when we export and reimport, important data is lost. We are told that if we go to a back up prior to the introduction of the corruption, we can reinstall from that date. But then we will have empty, important information that would have to be reinserted manually. The amount of date is very large. We suspect other files are also corrupted.

Is there an application that can scan FM database files looking for corruptions and reporting and even fixing them? Clearly, exporting these files in the upgrade process manages to identify these corruptions in the exporting engine, so there ought to be some way to sort this out.

We would appreciate any help we can get on this one!

Do a search for "character sieve". That one might help. But it scans only for corruption in data (by looking for low and high ascii characters that you'd normally not find in data). If the corruption is more in the file structure then there is no utility.

I know you're focused on getting the data back, but do take some time to evaluate your deployment: something is causing your databases to become corrupted and that needs to be remedied or your new files will corrupt too.