Tables could not be compared

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

fabioredgate29 August 19, 2008 06:16

Comments

1 comment

Hi,
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

David Atkinson August 19, 2008 06:26

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Tables could not be compared

Comments

Add comment