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.
Just as a note, this screencast shows an internal build of Visual Studio Orcas between the Feb CTP and Beta 1.