Unable to synchronize-no columns in the table can be updated

mikei

Two databases, one a clone of the other on separate servers, being compared with SQL Data Compare 10.4. Lots of differences found in tables, but selecting one particular I get the message 'x.x contains differences but cannot be synchronized because no columns in the table can be updated'
Account used is able to make entries in the table with SSMS and was previoulsy used with SQL Compare to mae minor adjustments to schema changes. Can't help but think I'm missing something blindingly obvious but I've been synching these two database over a couple of weeks and not run in to this before...

Anu D

Thanks for your post.

I have logged a support ticket for you and will email you shortly.

SQL_ME_RICH

I am having this same problem. Can anyone share what the solution was for this?