I have a complex database that was not authored by me. I think that
there may be some corruption problems with the scripts, so I'd like to
export the data from the latest version, and then re-import the data
into a clone of a previous version that is known to be good.
This file has a myriad of complex auto-enters, lookups, etc, that I
don't fully understand since the previous developer was not so good with
documentation, and he is not available for detailed help.
My thinking was that I could export the data as FileMaker format, then
re-import it to the empty clone and turn off the "Perform AutoEnter
Options While Importing".
My question is this: Are there any circumstances under which the
resulting data will not be an exact copy of the original data? For
example, I suspect that the FileMaker Status(CurrentRecordID) won't be
the same. Might there be any other problems? This file has some
tangled, complex self-relationships with auto-enters and lookup calcs,
and I'm worried I might miss some subtle differences.
Is there a way to verify that they are in fact identical? One idea to
verify the results would be to export a copy to text before and after
the re-import, and use a text file DIFF tool to compare the results.
To send email, remove the invalid and nospams.
||12/3/2003 6:04:31 PM