Support for ClickOnce, XCopy, MSI, CAB, and non-admin embedded installation options
Supports all Microsoft Windows embedded, mobile, desktop, and server operating systems
Supports a rich subset of Transact-SQL syntax and SQL Server data types
Microsoft Visual Studio 2008 integration
Supports ADO.NET, LINQ to SQL, LINQ to Entities, and the ADO.NET Entity Framework
Supports multiple concurrent local connections
Thank you for your reply.
One more doubt we have, that is can we restore backup file taken by SQL Server (i.e.*.bak) to SQL Server Compact database or convert .bak file to .sdf file in any way? or any tools available for such activities?