Sync database with filter using SyncOrchestrator with Sync Framework 2.0
Posted
by Flo
on Stack Overflow
See other posts from Stack Overflow
or by Flo
Published on 2010-03-25T09:32:03Z
Indexed on
2010/03/25
9:33 UTC
Read the original article
Hit count: 1041
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.
© Stack Overflow or respective owner