Hello!
I want to syncronise some tables from one database I have on a Local Server with others in an Azure Database by using the agent Microsoft SQL Data Sync . The collation I am using is Modern_Spanish_CS_AS .
I have the same collation in both databases however the collation of the master database is different, SQL_Latin1_General_CP1_CI_AS. While trying to sycornise I have this error:
"Database provisioning failed with the exception "Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Modern_Spanish_CS_AS" in the equal to operation."
How can I change this collation?
Thanks for your help.
María