Apr 16 2012, 12:39 PM
I need to know how to compare the contacts table in my database. There has been a recent upgrade that caused my db to crash.. I am trying to find the difference between the older version that works and the new version that Doesn't.
Thanks in advance fro the suggestions.
Apr 16 2012, 01:05 PM
On your query types, there is a find duplicates and a find unmatched query.
Apr 16 2012, 06:58 PM
If you're talking about changes to the STRUCTURE of the table, I'd suggest using the Database Documenter to document both databases (or at any rate this table in both databases), and compare the output of the documenter.
It would be a bit unusual for a table design change to make a database "crash". What's the nature of the crash? Have you Compacted and Repaired the crashing database? It would be even less likely for a change in the data stored in the (unchanged structure) tables to cause a crash, but if that's what you suspect then Milton's query suggestion would be the way to investigate.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here