Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-server-2005 C# SQL
I am working in c# windows application. The clients are given handheld devices and they should work offline.
My front end is C# windows and back end sql server 2005.
 
In each device I am having a local database , and saving in it. And when there is network , the client should click on a button and synchronise with server.
 
I dont have any idea in it. Please help me.!!
Thanks
Posted 2-Apr-13 21:17pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

The architecture plan is good! But synchronization is not an out-of-the-box task. It depends on your data, and the business needs. We can not tell you what do you have to synchronize.
For the "how to do it" part, you can make your method, or use us the ones by Microsoft: http://msdn.microsoft.com/en-us/library/cc761494(v=sql.90).aspx[^], http://blogs.charteris.com/blogs/ivorb/archive/2010/07/08/sync-framework-2-0-series-part-2-using-local-database-caching-for-an-occasionally-connected-application.aspx[^] - but these might need a little redesign.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Marcin Kozub 275
1 OriginalGriff 264
2 Sergey Alexandrovich Kryukov 215
3 Praneet Nadkar 197
4 Richard MacCutchan 182
0 OriginalGriff 8,048
1 Sergey Alexandrovich Kryukov 7,287
2 DamithSL 5,614
3 Manas Bhardwaj 4,986
4 Maciej Los 4,910


Advertise | Privacy | Mobile
Web02 | 2.8.1411023.1 | Last Updated 3 Apr 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100