CODEWITHSUNDEEP
c#windows-mobilefiltermicrosoft-sync-framework
0x49D1
0x49D1

Reputation: 8704

Is it possible to sync not whole table data in MS Sync Framework?

I have mobile application, so i dont want to send/receive whole changes in tables..Just some data, that meets some filter terms. Is it possible to achieve with SF; if it is, please provide some resources to read about it, because i found almost nothing.
Thank You.

Upvotes: 1

Views: 580

Answers (2)

JohnnyJP
JohnnyJP

Reputation: 1246

Yes its possible. For example you might only want to sync the records relating to a specific store, rather than all the changes in the store table.

You do this by adding a parameter to the SyncParameters collection. e.g.

m_SyncAgent.Configuration.SyncParameters.Add("@ParamName", paramValue)

This will pass the parameter data to the serverside of the Sync process, which you can then use to sync only the data you want to include.

Upvotes: 2

Jamie Ide
Jamie Ide

Reputation: 49301

It's definitely possible with SQL Server Replication Services (SSRS). You can select which tables, fields, and even apply filters to the publication. I'm not familiar with Sync Framework but SSRS subscriptions appear in the Sync Center, so my assumption is that Sync Framework uses SSRS.

Upvotes: 2

Related Questions