This forum is closed. Thank you for your contributions.

Sign in

Microsoft.com

Microsoft

Remove From My Forums

Get Change Batch

Question
0

Sign in to vote

Hello,

How can I get a change batch from a sqlSyncProvider? I've a server running a microsoft sql server 2005 some clients regester interest for some scopes on the server, my app requires batching the server changes in files and then download these files to client to apply.

Wednesday, June 16, 2010 7:48 AM

All replies

0

Sign in to vote
If you use SqlSyncProvider, you can just set the BatchingDirectory and MemoryDataCacheSize to enable the batching. The batches will be generated in the batching directory in the format of a bunch of batch files which are limited by MemoryDataCacheSize (in KB).

More information can be found at http://msdn.microsoft.com/en-us/library/dd918908.aspx
- Proposed as answer by jigu2014Microsoft employee, Editor Thursday, June 17, 2010 5:45 PM
Wednesday, June 16, 2010 5:08 PM

Answerer