I recently discovered that Microsoft is now offering SQL Server 2005 Compact Edition (SSCE). I read some of the white papers on the MS site and this sounds like it could be a good fit for a small desktop application. Easy to deploy with a download under 2 MB as compared to 50+ MB for SQL Express.
Has anyone attempted to work with compact edition yet? I would appreciate hearing about any experience you have had, both good and bad. Thanks in advance for any comments.
Kind Regards,
Mat