Asked by:
Syncing Windows Phone 6.5 Pro with SQL Server

Question
-
Hi,
I have a mobile app running on windows phone 6.5 (around 50 devices) I have a backend SQL server 2008 that will require to sync data from all the devices back and forth. I have looked into Sync Framework and Sync Toolkit but I am confused which version and which technology to use. My requirement is to sync data to and from each mobile device to backend database tables using filters. Please advice. Any sample will be highly appreciated.
Muhammad Umair umair.muhammad@hotmail.com MVP - Visual Basic Technologies
Sunday, May 12, 2013 10:07 PM
All replies
-
you can use either of them. Sync Fx has SQLCeClientSyncProvider that works on Windows Mobile 6.5.
the Sync Toolkit has examples for SQL CE as well that you can customize.
Monday, May 13, 2013 3:15 AM -
You should also consider using Merge Replication - http://blogs.msdn.com/b/sqlservercompact/archive/2009/11/09/merge-replication-vs-sync-services-for-compact.aspx
Please mark as answer, if this was it. Visit my SQL Server Compact blog Windows 8 Apps Showcase
Monday, May 13, 2013 6:12 AM -
Thanks a lot for this prompt response. Any sample and example to follow. Specially with merge replication.. seems interesting. Can I achieve it with hosted SQL database
Muhammad Umair umair.muhammad@hotmail.com MVP - Visual Basic Technologies
Monday, May 13, 2013 8:10 AM -
Look in SQL Server Books online, plent of sample and guidance. But Merge Replication will not Work on a hosted system... (Unless you can install stuff as admin)
Please mark as answer, if this was it. Visit my SQL Server Compact blog Windows 8 Apps Showcase
Monday, May 13, 2013 8:22 AM -
How about SQL Azure. Can I do it with SQL Azure?
Muhammad Umair umair.muhammad@hotmail.com MVP - Visual Basic Technologies
Monday, May 13, 2013 8:42 AM -
Sync Services, yes. Merge Replication, no.
Please mark as answer, if this was it. Visit my SQL Server Compact blog Windows 8 Apps Showcase
Monday, May 13, 2013 9:10 AM