Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
interesting architecture scenario RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello,
    i have an application i want to develop which requires me to develop an application (could be silverlight, WPF or web) which writes to a local SQL Compact database.

    This application will be installed on several laptops and they are required to periodically sync with a central SQL Server 2008 hosted centrally whenver they connect to the local network.

    There is no need for the clients to keep a copy of what is in the central database so i guess synchronization will only be in one direction ( all updates are to the central SQL Server).

    How can i design this solution with Sync Framework?

    Thanks
    Thursday, February 4, 2010 10:16 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    you can configure the sync direction in SyncFx to UploadOnly. You client would get the schema on first sync from the server and upload changes to server on subsequent syncs.
    • Proposed as answer by Rudi - Euricom Friday, February 5, 2010 2:39 PM
    • Marked as answer by femig Friday, February 5, 2010 3:53 PM
    Thursday, February 4, 2010 3:23 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    you can configure the sync direction in SyncFx to UploadOnly. You client would get the schema on first sync from the server and upload changes to server on subsequent syncs.
    • Proposed as answer by Rudi - Euricom Friday, February 5, 2010 2:39 PM
    • Marked as answer by femig Friday, February 5, 2010 3:53 PM
    Thursday, February 4, 2010 3:23 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    As June suggested, your best bet would be to use the Offline Scenario Providers, using the VS 2008 SP1 'local database cache' item.
    Then just set the Direction to UploadOnly.
    Friday, February 5, 2010 2:45 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Thanks,
    Any idea where i can get some tutorials or samples on this?
    Friday, February 5, 2010 3:53 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    The Local Database Cache uses the 'Offline Scenario' database providers, so you can get background info there.

    Google for 'Local Database Cache Visual Studio 2008'

    Friday, February 5, 2010 4:05 PM