question

NourNabhan-0668 avatar image
0 Votes"
NourNabhan-0668 asked ·

Database re-provisioning failed.

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?

azure-sql-database
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

pituach avatar image
1 Vote"
pituach answered ·

Good day @NourNabhan-0668,

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  
· 1 · Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @NourNabhan-0668

As conveyed above the issue is definitely with the collation as we get from the guidance from this document:
9006-datasync.jpg

Hope this helps.

Regards
Navtej S


1 Vote 1 · ·
datasync.jpg (133.0 KiB)