I'm looking for a script that will allow me to compare two identical tables lets call the table A and table B in different databases. Table A can be the master table.
1. The script ideally must shows rows where additional rows exists A which are not in B.
2. Where additional rows exist in B but not in A.
3. Also matching on a primary key it must show rows where values in any columns differ between rows.