Trying to set up synchronization between two SQL Azure databases

Question

Hi,

I tried to use the Sync feature on a database on North Europe datacenter to two other datacenters.

The sync hub was correctly configured, but I get this error on provisionning phase:

Database provisioning failed with the exception "The column "PourcentageRep" cannot be modified because it is either a computed column or is the result of a UNION operator.

Inner exception: SqlException Error Code: -2146232060 - SqlError Number:271, Message: The column "PourcentageRep" cannot be modified because it is either a computed column or is the result of a UNION operator. 
"

This column is indeed part of a view and the result of an union operator.

Can you give me some advices on how to handle this error please ?

Thanks.

---

R.

Answer 1

SQL Azure Data Sync does not support computed columns.

Answer 2

Hi,

Do you know if it will be supported in the future ?

Thanks for your help.

---

R.

Answer 3

i dont work for MS... you might want to suggest it in the feature voting site instead: http://www.mygreatwindowsazureidea.com/forums/44459-sql-azure-data-sync-feature-voting