Database re-provisioning failed.

Question

Trying to create data sync between 2 databases one on my local computer and the other is on Azure cloud, after creating sync agent and sync group and adding the needed tables to be synced an error appears preventing the sync process.

Database re-provisioning failed with the exception "Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation. Inner exception: SqlException ID: 92d7c5bf-96c9-4c43-a578-0cb9b678b044, Error Code: -2146232060 - SqlError Number:468, Message: SQL error with code 468 For more information, provide tracing ID ‘954e4a9d-f025-4919-a9cc-5f32e9e620e6’ to customer support."

Any help how to solve this?

Answer 1

Good day @Nour Nabhan ,

Seems like your COLLATE is not the same and this prevent you from sync. You should remember that COLLATE is directly related to the data encoding.

You can try to change the COLLATE of one of the database to fit the other, but you should understand the implications be fore doing so.

For example:

USE master;    
GO  
ALTER DATABASE Databases_Name  
COLLATE SQL_Latin1_General_CP1_CI_AS;    
GO    
--Verify the collation setting.    
SELECT name, collation_name    
FROM sys.databases    
WHERE name = Databases_Name';    
GO