Sharing the goodness…
Beth Massi is a Senior Program Manager on the Visual Studio team at Microsoft and a community champion for .NET developers. Learn more about Beth.
More videos »
Earlier today I posted a Channel 9 interview with Milind Lele showing us his favorite VS 2008 features - the new Data Synchronization designer and how the sync services for ADO.NET work to support occasionally connected scenarios. He shows us how to set up a local database cache using SQL Compact Edition and how to use it to store read-only data caches as well as how to add the code to support two-way synchronization. If anyone's ever tried to implement an occasionally connected smart client, they'll very much appreciate this new tooling and framework in Visual Studio 2008. For more information on sync services catch up on The Synchronizer blog.
PingBack from http://msdnrss.thecoderblogs.com/2007/10/10/channel-9-interview-offline-data-synchronization-services-in-visual-studio-2008/
Can we do the same with MS Access instead of SQL Server?!?
keep the local Data with SQLCe3.5 but synchronise with MS ACCESS?
Sync doesn't work with MS Access out of the box. You'd have to write your own Custom Sync Provider. Here's more info: http://msdn.microsoft.com/hi-in/library/bb902826(en-us).aspx