Sync don't work

Question

I try to sync two azure databases, when I'm creating sync, i push "Get schema" and have this error:

Getting schema information for the database failed with the exception "Failed to retrieve data for this request.
Inner exception: Operation not supported on version 11.0.
"

Для получения дополнительной информации предоставьте идентификатор трассировки "f7855bae-4395-40d0-bcbc-597dc3ed066a" в службу поддержки пользователей.

Answer 1

@Agibalov

Please take a look at this video which has a step by step procedure about how to synchronize Data from Cloud to Cloud using SQL Azure Data Sync.

---

Best Regards,
Peja

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 2

Thanks, Tao. But I do all as show this video. And when I push button "Get latest schema" (time 7:29 in video) i see progress bar long time and have this error

Getting schema information for the database failed with the exception "Failed to retrieve data for this request.
Inner exception: Operation not supported on version 11.0.
"

Для получения дополнительной информации предоставьте идентификатор трассировки "f7855bae-4395-40d0-bcbc-597dc3ed066a" в службу поддержки пользователей.

Answer 3

in which region are your sql azure databases hosted?

Answer 4

North Europe

Answer 5

i just created a new db in North Europe and its working fine...

can you try creating a temporary database, new table and see if you can get the schema for it?

Answer 6

If i create new temporary db with new table, I get schema successful. I see that trouble in my own schema, but i don't know why!

Answer 7

have a look at this and see if you have problems with data types: http://msdn.microsoft.com/en-us/library/hh667319.aspx

and this one as well for known issues: http://msdn.microsoft.com/en-us/library/hh667303.aspx

also, can you see any other error in the log viewer? 

Answer 8

This paper http://msdn.microsoft.com/en-us/library/hh667319.aspx  said that BIGINT not suported by sync. But I use it for IDs. How I can fix this trouble??

Answer 9

do you really need bigints? there's not much you can do about it if its the PK. if you can, just change the data type to a supported one like an int for example.  

Answer 10

I solve my trouble. It isn't BIGINT. My DB have Cyrillic_General_100_CI_AI sort parameter. When I change it to SQL_Latin1_General_CP1_CI_AS all work success. 

Answer 11

Currently DSS  does not support collation at column level. We are considering to add this feature at coming SUs.

---

Oliver Yao - MSFT