Sync Famework: how to enable bulk insert/update/delete stored procedures in Hub and spoke model
I am using MS Sync framework 2.1 in hub-spoke model with SQL Server 2008 and bunch of SQL Server 2008 Express clients.
The SyncAgent uses DbServerSyncProvider
as the RemoteProvider
.
Is there a way to enable bulk insert/delete/update stored proced开发者_开发知识库ures in this scenario to do the serverside operations, instead of processing data row by row?
Thanks
the Bulk operations in Sync Framework were only introduced in the collaboration/peer-to-peer database providers (SqlSyncProvider) in v2.1.
If you want to use DbServerSyncProvider, you will have to write a custom provider to enable that functionality.
If you can, i suggest you move to using the SqlSyncProvider instead.
精彩评论