I currently have a setup where I have a primary region and multiple secondary regions, each region has its own Azure Sql Server. The secondary regions only have a webfront end, they dont have the backoffice. I thought that I would be able to keep the secondary databases (those in secondary regions) in sync with the primary database use Azure Sql Data Sync (
https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database?view=azuresql)
I setup the primary db as the hub, with HubWins, and then setup a secondary database as a member (where the data should be replicated to) but some of the tables cause issues such as cmsContentNu, with the below message:
Database provisioning failed with the exception "Column 'dataRaw' in table 'dbo.cmsContentNu' is of a type that is invalid for use as a key column in an index.Inner exception: SqlException ID: aba23bf3-96ca-4464-a3c7-c01cb9a3fb2e, Error Code: -2146232060 - SqlError Number:1919, Message: SQL error with code 1919 For more information, provide tracing ID ‘d758e94b-8749-4f07-915e-0c375e09293c’ to customer support."
Does anyone have any experience with this situation, and have a solution to the above problem, OR a better solution than using SQL Data Sync for this setup?