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. 

http://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