Data Sync row size limit

Question

I use my database to store files of my application, and provide then by virtualpathprovider. Some of my files are greater than 10MB that appears to be the limit of Azure Data Sync:

"Sync failed with exception Cannot enumerate changes at the RelationalSyncProvider for table 'dbo.File'.  Check the inner exception for any store-specific errors.
Inner exception message: The row of size 14663KB from table 'dbo.File' cannot fit within the specified batch size of 10240KB. Row ID values: idFile = 1201. Consider increasing the value of RelationalSyncProvider.MemoryDataCacheSize for the source and destination providers."

Any way to do what error message says and increase the RelationalSyncProvider.MemoryDataCacheSize? I don't find where I can change this in the Azure Management Portal.

Answer 1

Hi, please ask SQL Azure data sync questions on this forum.

---

Please mark the replies as answers if they help or unmark if not.
If you have any feedback about my replies, please contact [e-mail].
Microsoft One Code Framework

Answer 2

I get the same error. If someone figures out where to make this change it would be highly appreciated.

Thanks

Answer 3

you cant change the batch size in the current release of the Sql Azure Data Sync Service.