Comparing Nearly Identical Database Tables
Suppose you have a database table named gw_geog which you've published online. So you actually have two copies of gw_geog - local and online.
Can anyone recommend a method for comparing these two tables? Let's say they each have 50,000 rows and they're absolutely identical, except for one field in one row that was changed in one table. Imagine a single cell which contains "washington" in one version and "Washington" (with a capital W) in the other.
I just wondered if there's a (hopefully not too technical) method for finding tiny differences between tables.