How can we help you today? How can we help you today?

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



Patrizio
0

Comments

3 comments

Sort by
  • Pete_Ruiz

    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


    Pete_Ruiz
    0
  • Patrizio
    Hello Pete,

    removing Include timestamp columns flag solve the issue.

    Thanks for your suggestion!
    Patrizio

    Patrizio
    0
  • Pete_Ruiz
    Hi @Patrizio ,

    Thanks for the update. I'm glad the option resolved the issue for you. Please do reach out if anything else comes up.

    Cheers,

    Pete Ruiz
    Pete_Ruiz
    0

Add comment

Please sign in to leave a comment.