In my schema I have a main table A which contains key data and a reference table B which contains reference data for each key in table A. For sync purposes I have a created a sync scope for table A, which allows me to sync any change in any row of table A. But for table B, instead of syncing all the rows, I just want to sync rows meeting certain criteria. Is it possible in sync 2.0? These filters are not static i.e. values for matching column (foreign key in my case) should be allowed to change through program.
With MSF V2.0 you can do filtering but with static filters. For Parameterized Filters (the scenario you have described above), the development team is currently working on it. I do not have schedule of it but you are more than welcome to check it at a later time.
Thanks.Leo Zhou
------
This posting is provided "AS IS" with no warranties, and confers no rights.
With MSF V2.0 you can do filtering but with static filters. For Parameterized Filters (the scenario you have described above), the development team is currently working on it. I do not have schedule of it but you are more than welcome to check it at a later time.
Thanks.Leo Zhou
------
This posting is provided "AS IS" with no warranties, and confers no rights.
So if we need dynamic table filters (i.e. only sync rows where EmployeeId=23), there is currently no solution in the Sync Framework 2.0? This could really be a show stopper for our current project. We have built up our new infrastucture around the Sync Framework 2.0, and put off the dynamic row filtering for syncing until now. So far our entire team is stumped as how to solve this issue. We have all taken a look at the SDK samples, especially the Sync101CustomFilter sample. But we have not been able to decipher as how to use it.
Error 22 Assembly 'Microsoft.Synchronization.Data.SqlServer, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' uses 'Microsoft.Synchronization, Version=2.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' which has a higher version than referenced assembly 'Microsoft.Synchronization, Version=1.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' c:\Program Files\Microsoft SDKs\Microsoft Sync Framework\2.0\Runtime\ADO.NET\V3.0\x86\Microsoft.Synchronization.Data.SqlServer.dll AzureSyncTest
Error 23 The base class or interface 'Microsoft.Synchronization.Data.RelationalSyncProvider' in assembly 'Microsoft.Synchronization.Data, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' referenced by type 'Microsoft.Synchronization.Data.SqlServer.SqlSyncProvider' could not be resolved c:\Program Files\Microsoft SDKs\Microsoft Sync Framework\2.0\Runtime\ADO.NET\V3.0\x86\Microsoft.Synchronization.Data.SqlServer.dll AzureSyncTest
Error 25 Assembly 'Microsoft.Synchronization.Data.SqlServer, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' uses 'Microsoft.Synchronization.Data, Version=3.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' which has a higher version than referenced assembly 'Microsoft.Synchronization.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' c:\Program Files\Microsoft SDKs\Microsoft Sync Framework\2.0\Runtime\ADO.NET\V3.0\x86\Microsoft.Synchronization.Data.SqlServer.dll AzureSyncTest
Error 26 Cannot implicitly convert type 'Microsoft.Synchronization.Data.SqlServer.SqlSyncProvider' to 'Microsoft.Synchronization.SyncProvider' C:\Users\w.ahmad\Desktop\SQL AZURE DataBase Tools\HDI-MSDN-Azure-source-IntegrateExistingAppSQLAzurePt2_CS\CS40\AzureSyncTest\Program.cs 21 48 AzureSyncTest
Error 27 Cannot implicitly convert type 'Microsoft.Synchronization.Data.SqlAzure.SqlAzureSyncProvider' to 'Microsoft.Synchronization.SyncProvider' C:\Users\w.ahmad\Desktop\SQL AZURE DataBase Tools\HDI-MSDN-Azure-source-IntegrateExistingAppSQLAzurePt2_CS\CS40\AzureSyncTest\Program.cs 24 50 AzureSyncTest
Can you plz help.
