Answered by:
sync framework for devices

Question
-
What is the current state on sync framework for devices? Im using windows mobile 6(Compact framework 3.5)
Am i stuck with "Microsoft Synchronization Services for ADO.NET" or is sync framework 2.1 with its new and improved providers supporting devices? Im a bit confused about this and have been googling the answer for way to long. Alot of the posts i find on this is dated to 2007-2009 (Sync framework 1.0). is this stil the way to do it on devices in 2012?
Some info about Project:
I need to use WCF for transport because of firewall rules.
Components:
Server: SQL server 2008 database using a wcf service.
Client: SQL CE database and Wcf ("basicHttpBinding") client
I need to sync these two databases initiated from client when it gets online. I allso need to filter synchronize data on which user is logged in on PDA and also need batching to preserve RAM. I have done the actual synchronization using the "Microsoft Synchronization Services for ADO.NET" way, tutorial used: (http://msdn.microsoft.com/en-us/library/dd938879.aspx). But performance is unacceptable, and i need to improve it. Filtering and batching is step 1, later ill look into compression. Any suggestions welcome.
Wednesday, February 8, 2012 2:01 PM
Answers
-
for WM devices, "Microsoft Synchronization Services for ADO.NET" is still your choice out of the box. the 2.1 release is not much for devices.
for performance, you might want to check out using Dataset Surrogates (the newer database sync providers uses it). see: http://jtabadero.wordpress.com/2010/03/08/sync-framework-wcf-based-synchronization-for-offline-scenario-%e2%80%93-using-custom-dataset-serialization/
a newer alternative will be the Sync Toolkit (which was supposed to be Sync Framework v4), see: http://code.msdn.microsoft.com/Sync-Framework-Toolkit-4dc10f0e
I believe it has samples for WM6.5
- Marked as answer by Anonymous12356434 Thursday, February 9, 2012 8:08 AM
Wednesday, February 8, 2012 2:11 PM -
There is also this CodePlex project: http://synccomm.codeplex.com/
Please mark as answer, if this was it. Visit my SQL Server Compact blog
- Marked as answer by Anonymous12356434 Thursday, February 9, 2012 8:08 AM
Wednesday, February 8, 2012 2:42 PM
All replies
-
for WM devices, "Microsoft Synchronization Services for ADO.NET" is still your choice out of the box. the 2.1 release is not much for devices.
for performance, you might want to check out using Dataset Surrogates (the newer database sync providers uses it). see: http://jtabadero.wordpress.com/2010/03/08/sync-framework-wcf-based-synchronization-for-offline-scenario-%e2%80%93-using-custom-dataset-serialization/
a newer alternative will be the Sync Toolkit (which was supposed to be Sync Framework v4), see: http://code.msdn.microsoft.com/Sync-Framework-Toolkit-4dc10f0e
I believe it has samples for WM6.5
- Marked as answer by Anonymous12356434 Thursday, February 9, 2012 8:08 AM
Wednesday, February 8, 2012 2:11 PM -
There is also this CodePlex project: http://synccomm.codeplex.com/
Please mark as answer, if this was it. Visit my SQL Server Compact blog
- Marked as answer by Anonymous12356434 Thursday, February 9, 2012 8:08 AM
Wednesday, February 8, 2012 2:42 PM