CODEWITHSUNDEEP
azureazure-sql-database
Nour Nabhan
Nour Nabhan

Reputation: 11

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?

Upvotes: 1

Views: 1242

Answers (1)

NavtejSaini-MSFT
NavtejSaini-MSFT

Reputation: 121

The Document provides the guidance regarding the collation in DataSync. It really depends on the way you do the sync. Here is what it says: enter image description here

Please review the same and if you have any further question or need any further help, please get back to us.

Thanks Navtej S

Upvotes: 0

Related Questions