Given that most Windows Azure SQL Database customers are now advised to use with custom sharding pattern for scale-out, we are re-evaluating when you would want to use sync for a sharded environment – is it syncing from on-prem SQL Server to multiple shards in the cloud, synchronizing between the shards in the cloud, or syncing from multiple shards down to on-prem SQL Server? We’d appreciate your input on this.Bart X. Tubalinal shared this idea ·
This is a very interesting idea! We would like to know what specific usage you have in mind – for example, are you continuously generating operational logs on-prem and would like an utility to easily upload these files into blob storage for further analysis, maybe using HDInsight? Please post your comments!Bart X. Tubalinal commented
This should be possible with the Sync Framework. This link is old but should still be applicable: http://blogs.msdn.com/b/sync/archive/2009/12/03/synchronizing-files-to-windows-azure-storage-using-microsoft-sync-framework.aspx
Data Sync team is planning to improve initial synchronization performance by using bulk insert and other optimization techniques.
Good idea and it ties to the idea on monitoring APIs. We will consider this.
We will evaluate the priority for this.Bart X. Tubalinal commented