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

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

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

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

Postby Anu Deshpande » Wed Jan 29, 2014 4: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: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

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

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


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest