Azure Data Sync Error

Question

Hello,

I am synchronizing the database to azure but I am getting the following error :

Error:

Sync failed with the exception "We have encountered an issue in syncing your data."

For more information, provide tracing id ‘853dea48-4cf0-4406-939a-2fb30dbaa09c’ to customer support.

Before I was able to sync the database. That time I selected the only few tables but now I selected the full database and getting the error.

Please help.

Thanks

Dev

Answer 1

Hi Devendar sipl,

Regarding to your description seems you was able to sync few tables, but was not able to sync full database. That might be because of the some rows’ size exceeded the maximum batch size which is 10m currently.

---

Regards, Amber zhang

Answer 2

Hi Amber zhang,

Thanks for the reply.

Do you have any solution or suggestion for this problem I am having? Also, do you know how to get which rows are causing the problem?

Awaiting your response.

Regards

Devendra

Answer 3

are you storing any blobs in your tables? unless you're storing image, files, etc...in your tables, its very unlikely you will exceed the 10mb limit.

also, what are you trying to sync? on-prem to azure? azure to azure?

Answer 4

Hello JuneT,

I want to host my SQL Server R2 database to azure. I am using "on-prem to azure" service.

Yes, I am storing the blob data (Video).

Thanks for the reply.

Regards

Devendra

Answer 5

then you cant do much about it. the batch size is limited to 10mb. if you have a row whose size including the video is greater than 10mb, that would fail.

Answer 6

Is there any other ways to host the sql database on azure?

Actually I have a in use database and I have to host it as-it-is.

Answer 7

of course you can host, what im saying is that you can't use the Data Sync service to synchronize the blobs given that they exceed the maximum batch size.

are you trying to setup sync or are you just trying to get your on-premise database to Azure?

also, please note that an on-premise SQL Server is not feature equivalent with Azure SQL Database, so you might want to check the differences.

Answer 8

are you trying to setup sync or are you just trying to get your on-premise database to Azure?

It is not important to setup sync for me. To get your on-premise database to Azure is my requirement.

I am having about 2-3 application which are sharing the same database. I am moving the applications on azure and want to move the database on azure too. Sync to azure and on-premise is not necessary.

Finally I just want my database [With the data it contains into] on azure.

Answer 9

i suggest you have a look at the SQL Azure Migration Wizard: http://sqlazuremw.codeplex.com/

or http://bluesyntax.net/DataCopy.aspx

Answer 10

Thanks you your most valuable suggestions.