Microsoft Sync Framework 2.1 Dynamic Sync between server and clients

1
votes

I am looking for the best way to achieve the dynamic sync between server and clients. I have a central server and n-number of clients. I have designed a sync framework which will sync the data from and to between server and each client.

Here each client data is segregated by 2 filter columns. If I hard code these values for each client, then it will create one set of Sp' for each client (ex: selectchanges sp).

How can I achieve this dynamically? Please provide some sample code.

1
sqlsql-server-2008-r2frameworkssynchronizationmicrosoft-sync-framework
Can be closed under: Questions asking us to recommend or find a book, tool, software library, tutorial or other off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it. - halfer

1 Answers

0
votes

if by dynamic, you meant dynamic filtering, it's not supported.

however, if you're concern is having one selectchanges SP for each client, you can use Filter templates so all the clients share the same SP but use different parameter values.