SQL Server 2005 Compact Edition: The Little Engine That Can

Microsoft SQL Server 2005 Compact Edition (SQLce) is the newest version of Microsoft's mobile database solution. SQLce provides relational database functionality for mobile and desktop applications through a lightweight and easily distributable engine. Applications that need relational database capabilities but are not connected or only sometimes connected to a network can benefit greatly from SQLce.

The article continues at http://www.developer.com/db/article.php/3653821