>Anything simple to compare tables and show the differences? Even it was SQL that created a cursor of the records that do not match would be fine.

select TableA.* from TableA LEFT JOIN TableB ON ... WHERE TableB.PK Is NULL ;
union all ;
select TableB.* from TableB LEFT JOIN TableA ON ... where TableA.PK IS NULL

Or the same with full outer join and both PKs NULL.