Sync database with filter using SyncOrchestrator with Sync Framework 2.0

Question

Hi,

I want to synchronize two SQL databases. But since one of the databases only requires a subset of the data I am looking for a filter option. Is there a possibility to add a Filter to the SyncOrchestrator or do I have to add the filter to the SyncProvider?

According to this: http://social.microsoft.com/Forums/en-US/uklaunch2007ado.net/thread/35d4deb8-a861-4fe3-a395-d175e14c353f it is not possible to filter with the DbSyncProvider.

Quote: "I understand your scenario, and the hebavior of the DbSyncProvider is due to the current limitation. DbSyncProvider is built on top of the Microsoft Sync Framework that can support filtering. Unfortunately, DbSyncProvider does not yet."

But that post is quite old, maybe that has changed now.

I am working with this example at the moment: http://msdn.microsoft.com/en-us/library/cc807255.aspx but I can't figure out how to add filtering here.

Answer 1

http://jtabadero.spaces.live.com/blog/cns!BF49A449953D0591!1187.entry http://social.microsoft.com/Forums/en/syncdevdiscussions/thread/4af321b6-4678-4620-af46-98c560cc2bc6

HTH