sql data compare message
I am using SQL Data Compare to compare a database to a previous backup of the same database, to determine which tables are being updated by automated import processes.
I have alot of tables which cannot be compared - the message given is:
Row differences cannot be displayed because the objects cannot be compared. Ensure that object mappings and comparison keys are set correctly.
This is most likely due to bad table design, where there are no unique keys.
Can I compare these tables?