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

Patrizio

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

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

Patrizio

Hello Pete,

removing Include timestamp columns flag solve the issue.

Thanks for your suggestion!

Patrizio

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