In this video, Rob Windsor shows how to create an occasionally connected application that will consume data from a local database and periodically synchronize this data store with the server-side database.
Originally posted on MSDN: How do I: Create Occasionally Connected Client Applications?