I am happy to report  SQL Server Compact Edition is now available: it is as a free, lightweight, embeddable database offering for desktop and mobile application development. SOme of the key benefits:

  • Simple deployment to Windows Mobile 5.0 powered devices (and it's Free!)
  • Merge replication: Synchronization servces to AQL Server enables distributed, occasionally connected apps to take their data anywhere, anytime.
  • The power of a full SQL engine with full transaction support, inner and outer joins, a full set of data types and full referential integrity with cascading deletes and updates.
  • Tight integration with Visual Studio and the .NET Framework which means you have a common programming model, a familiar query syntax - no learning curve.
  • 128-bit file encryption.
  • Integration with the business intelligence features of SQL Server.
 This product replaces SQL Server Mobile and SQL Server Everywhere - yes, the branding for this product has been confusing. Click here to lean more on TechNet.