Filtering data in database synchronization RRS feed

  • Question

  • Hi All!

    I have configured synchronization between (SQL Server 2008 and SQL Server CE) with Sync Framework. The server side is represented as a WCF service running on a remote server.
    For the track changes using change tracking (introduced in SQL Server 2008).

    At the moment need to implement filtering of data when synchronizing databases. For the answer, I turned to the MSDN link:
    http://msdn.microsoft.com/ru-ru/library/ff928701% 28v = SQL.110% 29.aspx

    I think the examples I can understand.

    But me care only one the question, most of the code for synchronization generated by Visual Studio.
    Where is the best (and more right) to declare an object SqlSyncScopeProvisioning and others object for set up filtering of data.

    May be in OnInitialize (SyncAgent object)?

    Perhaps everything is much easier ... and the generated code, there are places where will need to add the required filters.

    How is better do?



    • Moved by Bob Beauchemin Wednesday, May 4, 2011 8:16 PM Moved to a more relevent forum (From:.NET Framework inside SQL Server)
    • Moved by ErikEJMVP Thursday, May 5, 2011 6:21 AM (From:SQL Server Compact)
    Wednesday, May 4, 2011 2:40 AM