dfincham28
asked on
Table data comparison script
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
SQL Delta is a better professional tool
ASKER
Someone at work has solved the problem for me
ASKER