What are the challenges you face when working across database platforms? Take the survey
Options

Table [tablename] contains differences. However, these cannot be synchronized ...

Hi,

using SQL Data Compare 14.2.9 between SQL Server 2016 (source) and SQL Server 2017 (target) I got the following error message:

Table [tablename] contains differences. However, these cannot be synchronized because no columns in the table can be updated.

tables content is the same but application see all rows as different, deployment script doesn't contains any update command (as expected); tables have usual primary keys (default int type).

Any suggestion?

Thanks
Patrizio



Tagged:

Best Answer

  • Options
    Pete_RuizPete_Ruiz Posts: 123 Silver 4
    Answer ✓

    Hello @Patrizio


    This error can sometimes be due to lack of permissions, can you please review the permissions on the target? Also, sometimes caused by differences in timestamp columns. By default, the option to include timestamp columns is enabled, do you show differences if you disable this option?



    Kind regards,


    Pete Ruiz


Answers

Sign In or Register to comment.