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

Compares and synchronizes SQL database content.

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

Postby mikei » Wed Jan 29, 2014 12:23 am

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...
Posts: 1
Joined: Wed Jan 29, 2014 12:06 am

Postby Anu Deshpande » Wed Jan 29, 2014 3:50 pm

Thanks for your post.

I have logged a support ticket for you and will email you shortly.
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
Posts: 838
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Postby SQL_ME_RICH » Fri Apr 25, 2014 8:29 pm

I am having this same problem. Can anyone share what the solution was for this?
Posts: 82
Joined: Tue May 08, 2012 9:41 pm

Return to SQL Data Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests