Smart Client: Offline Data Synchronization and Caching with SQL Server Everywhere

Steve Lasker
SQL Dev Team

This session started out with a description of the different SQL Server versions available and their uses:

SQL Server (and up) - Multi user, high end

MSDE (MS Desktop Engine - Single user, usually application specific instances

SQL Server 2005 Express Edition - Replacement for MSDE

SQL Server Mobile - Developed for offline storage of data on mobile devices

SQL Server Everywhere - Combines the functionality of SQL Server Mobile and SQL Server Express (One platform for all single user applications)

Next he walked us through different scenarios for offline storage and sychronization methods and where they might apply.