SQL 2008 Building Occasionally Connected Systems
Building Occasionally Connected Systems
With mobile devices and workers on-the-go, occasionally connected has become a way of life. SQL Server 2008 delivers a unified synchronization platform that enables consistent synchronization across applications, data stores, and data types. In a joint effort with Visual Studio, SQL Server 2008 enables the rapid creation of occasionally connected applications by way of new synchronization services in ADO.NET and offline designers in Visual Studio. SQL Server 2008 provides support for change tracking, enabling customers to develop caching-based, synchronization-based, and notification-based applications using a robust implementation with minimal performance overhead. You would think the setup on this would be pretty challenging. Think again. I recorded a demo of how the process works and it is not really that hard to do.