I just confuse with Smart Client from Isomorphic Software. I am not sure about the Smart Client that Microsoft introduced. I think it is the usual Compact Framework that is used in PPC / Smartphone.
Back to the Leon question regarding database sync, In Visual Studio 2008 has the solution. It is called Local Database Cache. It is SQL CE file with .sdf extension. It is used to store data locally within the application. It just a half way. Just like the link that Benj provide, the service that act as sync provider between SQL Server and SQL CE is Microsoft Sync Framework This is another half that you need to study. There a lots of example I found at last time (Q4 last year) I design the project just like you want to do. You can try search by occasionally connected, SQL CE and Microsoft Sync Framework key word. but remember that most of the example is for Windows Form and WPF. If you want it in Compact Framework PPC or Smartphone, you will need a trick to do that. I think this the "miss" by Microsoft before releasing VS 2008. The Service Pack 1 also don't have. I found the example to do the trick but not remember the link right now. I mention trick because there is no official way provided by VS2008 to do the CF project with SQL CE and SyncProvider. The example show to create dummy WinForm project before creating CF project. CallMeLaNN
