I'm comparing 2 dbs (1 SQL 200R2, 1 SQL 2008) and the 2008 one has been created using SQL Compare from the 2008 R2 one.
Now i am trying to do a Data Compare so it can deploy all the data from 2008 R2 to the 2008 empty database.
However, 128 of the tables could not be compared and this is because the comparison key was not set automatically by SQL Data Compare. Why is this? Do i need to map these manually? Is there a better way?