From Microsoft.com: "Microsoft SQL Server 2005 Everywhere Edition offers essential relational database functionality in a compact footprint ideal for embedding in mobile and desktop applications including a new generation of occasionally connected dynamic applications." I'm not sure I agree.Here is my inital list of pros/cons from a developers point of view:ProsCompletely run in-proc, meaning there is no installation requiredFree to develop, deploy and redistributeAllows up to 4GB databasesSupport for up to 256 connectionsVery compact (max of 7 DLLs required at 1.4 MB)ConsNo user interface available (I had to create my database through code)...I'm sure a 3rd party will develop one very soon.Support for only a limited number of datatypes - for example, supports nvarchar, but not varchar or the XML data type!Does not support stored procedures, views, triggers, extended stored procedures, or macros.Sample ApplicationThe code is not that complicated, so I'm not going to write up a technical explanation. But in my overall opinion, this product seems to be a much more powerful version of Access without the interface. I don't see myself using it anytime soon.I spent a few hours reading about SQL Server Everywhere and put together this sample application.Download Sample ApplicationForm1.csUseful linksDownloaded SQL Server Everywhere: http://www.microsoft.com/sql/ctp_sqleverywhere.mspxPaul Flessner announced SQL Server Everywhere: http://www.microsoft.com/sql/letter.mspxSteve Lasker's Blog - Interview with Paul Flessner: http://blogs.msdn.com/stevelasker/archive/2006/04/10/SqlEverywhereInfo.aspx
But you do have an interface. You can use the SQL Server 2005 Management Studio.
KeyLimeTie is a full-service design, development & digital strategy agency, helping clients communicate more effectively and intimately with their customers through interactive marketing channels.
Specializing in web and mobile application development across a variety of platforms, KeyLimeTie provides content management, ecommerce, and custom application solutions, while also assisting customers with social media campaign and reputation management.