Tables could not be compared
fabioredgate29
Posts: 4
Hi
I have just used SQL Data Compare 7 to compare two databases and the results of the comparison reveal that 5 tables could not be compared.
A SQL Compare 7 schema comparison reports that that tables are identical so I would please like to know why SQL Data Compare is unable to compare these tables?
Thanks and best regards,
Fabio
I have just used SQL Data Compare 7 to compare two databases and the results of the comparison reveal that 5 tables could not be compared.
A SQL Compare 7 schema comparison reports that that tables are identical so I would please like to know why SQL Data Compare is unable to compare these tables?
Thanks and best regards,
Fabio
Comments
Thanks for your query. I'm guessing that there may not be a natural comparison key for those tables?
See the comparison key section at http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Data%20Compare&c=SQL_Data_Compare/help/7.0/SDC_SelectingObjects.htm&toc=SQL_Data_Compare/help/7.0/toc43727.htm
If this is the case, you can set your own by selecting "Edit Project", and using the dropdownlist in the Comparison Key column.
If this still doesn't work, please let us know.
Kind regards,
David Atkinson
Red Gate Software
Product Manager
Redgate Software