You are developing an occasionally connected smart client database application. When the application is offline, users must be able to enter data. When the application returns online, it should upload added data to a corporate Microsoft SQL Server database.

You must choose a solution for offline caching and synchronization. Synchronization should require the least amount of developer effort, and caching should require a minimal footprint.

What should you do?

Sync Services lets you synchronize data from different sources over two-tier, N-tier, and service-based architectures. The Sync Services application programming interface for client and server synchronization provides a set of components to synchronize data between data services and a local store, instead of only replicating a database and its schema. Choose SQL Server Compact 3.5 for a compact footprint. Use the Local Database Cache feature in Microsoft Visual Studio 2008 to ensure minimal developer effort.