Data difference between two Access databases

  • Thread starter Thread starter Srinivas Paruchuri
  • Start date Start date
S

Srinivas Paruchuri

Are there any tools out there to find data differences between two Access
databases?

thanks,
Chowdary
 
Srinivas Paruchuri said:
Are there any tools out there to find data differences between two Access
databases?
Click to expand...

If they aren't too big, you can make copies of both files and combine them
into 1 bigger file. Then you will have tables like:

Table1 and Table11
Table2 and Table21
etc.

Create queries with outer joins in both directions:

SELECT Table1.*, Table11.ID
FROM Table1 LEFT JOIN Table11 ON Table1.ID = Table11.ID
WHERE (((Table11.ID) Is Null));

SELECT Table11.*, Table1.ID
FROM Table1 RIGHT JOIN Table11 ON Table1.ID = Table11.ID
WHERE (((Table1.ID) Is Null));

The differences, based on the primary key (ID) will be returned.

You can also use a program like ExamDiff to check for differences, but that
will only compare ASCII values correctly, not actual data.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Thanks for quick replies. Hope MS will provide this feature in the future
versions.

I think it is essential feature to find differences and synchronize those
changes in Access and Excel tools.

thanks,
Chowdary
 
Back
Top