Want to learn more about SQL Compact Edition? You can start by reading everything over at
Microsoft's web site, or you can read some of the chapters out of the upcoming book "
Windows Mobile Data Synchronization with SQL Server 2005 and SQL Server Compact 3.1", for free at
Rob Tiffany's blog. He's posted 3 or 4 chapters from the book on his site for download, covering off stuff like configuring the publisher/distributor, and web sync. It's in PDF format, but you can just grab a copy of FoxIt or FoxIt Mobile (for your Windows Mobile device) and you're off to the races.