First look at the Visual Studio Orcas Sync Designer
Here's part 1 of the new Sync Designer. In this screen cast I walk through how to cache lookup tables locally. In this screencast I use the 2 tier sync, starting simple. In the next screencast I'll show how to take the same designer, and split it across N tier to keep the intimate knowledge of the server, connection string, queries, passwords, etc. from the client.
https://channel9.msdn.com/posts/SteveLasker/Visual-Studio-Orcas-Sync-Designer-for-Caching-Data-in-SQL-Server-Compact-Edition/
Just as a note, this screencast shows an internal build of Visual Studio Orcas between the Feb CTP and Beta 1.
Steve